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

From Neil Conway
Subject Re: locks in CREATE TRIGGER, ADD FK
Date
Msg-id 4241038A.30201@samurai.com
Whole thread Raw
In response to Re: locks in CREATE TRIGGER, ADD FK  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: locks in CREATE TRIGGER, ADD FK
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: "they only drink coffee at dec"