Re: locks in CREATE TRIGGER, ADD FK - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: locks in CREATE TRIGGER, ADD FK
Date
Msg-id 4240D779.3070103@familyhealth.com.au
Whole thread Raw
In response to Re: locks in CREATE TRIGGER, ADD FK  (Russell Smith <mr-russ@pws.com.au>)
Responses Re: locks in CREATE TRIGGER, ADD FK  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: locks in CREATE TRIGGER, ADD FK  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>If you want to be my friend forever, then fix CLUSTER so that it uses 
>>sharerowexclusive as well :D
> 
> I don't think it's as easy as that, because you have to move tuples
> around in the cluster operation.  Same sort of issue as vacuum full I would suggest.

Cluster doesn't move rows...

I didn't say it was easy.  It would involve changing how cluster works.  It would keep the old table around while
buildingthe new, then grab 
 
an exclusive lock to swap the two.

Chris


pgsql-hackers by date:

Previous
From: Russell Smith
Date:
Subject: Re: locks in CREATE TRIGGER, ADD FK
Next
From: Bruce Momjian
Date:
Subject: Re: psql and pg_dump using obselete copy commands