From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Static snapshot data |
Date: | 2003-05-23 19:31:30 |
Message-ID: | 200305231931.h4NJVUx03339@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Manfred Koizar wrote:
> On Fri, 23 May 2003 13:15:07 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> wrote:
> >[good reasons for having SERIALIZABLE subtransactions in READ
> > COMMITTED main transactions]
>
> All I'm saying is if we can have
> (1) a simple version with some restrictions for 7.4 and
> SERIALIZABLE subtransactions for 7.5 or
> (2) nothing for 7.4 and everything for 7.5
> I'd rather have (1); as long as we don't cause incompatibilities, of
> course.
Agreed. Let's get this boat in the water first unless it will be harder
add this functionality later.
> >We already have START TRANSACTION [...]
>
> Great. I was so used to BEGIN that I didn't even think of trying \h.
> :-/
I am just now realizing that because autocommit off is assumed, there
wasn't any being transaction statement in SQL92, and the only standard
one is in SQL99 and it is START TRANSACTION, not BEGIN WORK. I thought
BEGIN WORK was standard, but I guess not.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Houssay | 2003-05-23 19:49:14 | Postgresql on SUN Server |
Previous Message | Tom Lane | 2003-05-23 19:13:36 | Plan B for log rotation support: borrow Apache code |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2003-05-23 22:35:43 | Domain casting still not working right? |
Previous Message | Tom Lane | 2003-05-23 18:53:24 | Re: Static snapshot data |