Skip site navigation (1) Skip section navigation (2)

Re: FOREIGN KEY and AccessExclusiveLock

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: FOREIGN KEY and AccessExclusiveLock
Date: 2004-09-28 13:34:43
Message-ID: Pine.LNX.4.44.0409281632260.30263-100000@matrix.gatewaynet.com (view raw or flat)
Thread:
Lists: pgsql-sql
O Tom Lane έγραψε στις Sep 28, 2004 :

> Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)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


In response to

pgsql-sql by date

Next:From: T E SchmitzDate: 2004-09-28 14:02:02
Subject: CHECK col A not NULL if col B='x'
Previous:From: Martin MarquesDate: 2004-09-28 12:55:23
Subject: Best way to know if there is a row

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group