Re: locks in CREATE TRIGGER, ADD FK

From: "Zeugswetter Andreas DAZ SD" <ZeugswetterA(at)spardat(dot)at>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "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 11:28:21
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA40184D361@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> > 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.

It would need a whole of new family of "intent" locks, with different rules.

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2005-03-23 13:07:23 Re: odd problem !
Previous Message Oleg Bartunov 2005-03-23 08:24:31 Re: odd problem !