Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about ALTER TABLE SET TABLESPACE locing behaviour - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Question about ALTER TABLE SET TABLESPACE locing behaviour
Date
Msg-id 6314.1138835329@sss.pgh.pa.us
Whole thread Raw
In response to Question about ALTER TABLE SET TABLESPACE locing behaviour  (Hannu Krosing <hannu@skype.net>)
Responses Re: Question about ALTER TABLE SET TABLESPACE locing
List pgsql-hackers
Tree view 
Hannu Krosing <hannu@skype.net> writes:
> Does ALTER TABLE SET TABLESPACE lock the table

It had better ... see nearby discussion about relaxing locking for
TRUNCATE.  Exactly the same problem that at commit we'd be cutting
the ground out from under any concurrent query.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Question about ALTER TABLE SET TABLESPACE locing behaviour
Next
From: Christopher Kings-Lynne
Date:
Subject: 8.1.3?