Re: FOREIGN KEY and AccessExclusiveLock - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: FOREIGN KEY and AccessExclusiveLock
Date
Msg-id Pine.LNX.4.44.0409290835500.32393-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Re: FOREIGN KEY and AccessExclusiveLock  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
O Tom Lane έγραψε στις Sep 28, 2004 :

> Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> > Whats the purpose of the AccessExclusiveLock on parent table?
> 
> We're adding a trigger to it.

From the docs:

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.

Now is the lock in question created explicitly with LOCK TABLE?
Since the docs dont say a thing about triggers acquiring locks.



> 
>             regards, tom lane
> 

-- 
-Achilleus



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: CHECK col A not NULL if col B='x'
Next
From: Marco Gaiarin
Date:
Subject: Re: Porting problem from Informix to Postgres...