Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: locks in CREATE TRIGGER, ADD FK
Date
Msg-id 1447.1111550865@sss.pgh.pa.us
Whole thread Raw
In response to Re: locks in CREATE TRIGGER, ADD FK  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>   It would keep the old table around while building the new, then grab 
> an exclusive lock to swap the two.

Lock upgrading is right out.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: locks in CREATE TRIGGER, ADD FK
Next
From: Neil Conway
Date:
Subject: Re: locks in CREATE TRIGGER, ADD FK