Re: locks in CREATE TRIGGER, ADD FK

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Russell Smith <mr-russ(at)pws(dot)com(dot)au>, Neil Conway <neilc(at)samurai(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: locks in CREATE TRIGGER, ADD FK
Date: 2005-03-23 04:07:45
Message-ID: 1447.1111550865@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-03-23 04:09:11 Re: locks in CREATE TRIGGER, ADD FK
Previous Message Tom Lane 2005-03-23 04:06:18 Re: locks in CREATE TRIGGER, ADD FK