| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2005-03-23 06:13:31 | Re: "they only drink coffee at dec" |
| Previous Message | Neil Conway | 2005-03-23 05:16:36 | Re: locks in CREATE TRIGGER, ADD FK |