Hmm, (something went wrong with some mailer)
Tom Lane wrote:
> We're adding a trigger to it.
From the docs:
Conflicts with locks of all modes (ACCESS SHARE, ROW SHARE, ROW
EXCLUSIVE, SHARE UPDATE EXCLUSIVE, SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE,
and ACCESS EXCLUSIVE). This mode guarantees that the holder is the only
transaction accessing the table in any way.
Acquired by the ALTER TABLE, DROP TABLE, REINDEX, CLUSTER, and VACUUM FULL
commands. This is also the default lock mode for LOCK TABLE statements
that do not specify a mode explicitly.
Tip: Only an ACCESS EXCLUSIVE lock blocks a SELECT (without FOR UPDATE)
Now, is the lock acquired for the CREATE TRIGGER an explicit
Because nothing is mentioned about triggers in
In response to
pgsql-sql by date
|Next:||From: Marco Gaiarin||Date: 2004-09-29 13:21:21|
|Subject: Re: Porting problem from Informix to Postgres...|
|Previous:||From: Achilleus Mantzios||Date: 2004-09-29 05:36:07|
|Subject: Re: FOREIGN KEY and AccessExclusiveLock |