Skip site navigation (1) Skip section navigation (2)

Re: Question about ALTER TABLE SET TABLESPACE locing behaviour

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hannu Krosing <hannu(at)skype(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Question about ALTER TABLE SET TABLESPACE locing behaviour
Date: 2006-02-01 23:08:49
Message-ID: 6314.1138835329@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Hannu Krosing <hannu(at)skype(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2006-02-02 01:15:59
Subject: 8.1.3?
Previous:From: Hannu KrosingDate: 2006-02-01 21:44:59
Subject: Question about ALTER TABLE SET TABLESPACE locing behaviour

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group