Postgres Pro
Downloads
Home   >   mailing lists

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

From Zeugswetter Andreas DAZ SD
Subject Re: locks in CREATE TRIGGER, ADD FK
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D361@m0114.s-mxs.net
Whole thread Raw
In response to locks in CREATE TRIGGER, ADD FK  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Tree view 
> >   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

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: odd problem !
Next
From: Simon Riggs
Date:
Subject: Re: odd problem !