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

Re: locks in CREATE TRIGGER, ADD FK

From: Neil Conway <neilc(at)samurai(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: locks in CREATE TRIGGER, ADD FK
Date: 2005-03-23 05:50:02
Message-ID: 4241038A.30201@samurai.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:
> This is presuming that we abandon the notion that system catalog
> access use SnapshotNow.  Which opens the question of what they should
> use instead ... to which "transaction snapshot" isn't the answer,
> because we have to be able to do system catalog accesses before
> we've set the snapshot.

I wonder if it would be possible to use SnapshotNow before the 
transaction's snapshot has been established, and the transaction's 
snapshot subsequently. Although it definitely makes me nervous to use 
multiple snapshots over the life of a single transaction...

-Neil

In response to

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2005-03-23 06:13:31
Subject: Re: "they only drink coffee at dec"
Previous:From: Neil ConwayDate: 2005-03-23 05:16:36
Subject: Re: locks in CREATE TRIGGER, ADD FK

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