From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Zeugswetter Andreas SEV <ZeugswetterA(at)wien(dot)spardat(dot)at>, "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgreSQL(dot)org>, "'Bruce Momjian'" <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Subject: | Re: [HACKERS] SQL statements: begin and end |
Date: | 1999-11-23 16:15:21 |
Message-ID: | Pine.BSF.4.05.9911231108240.23191-100000@paprika.michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 23 Nov 1999, Tom Lane wrote:
> My feeling is that application authors have already decided whether
> they prefer "BEGIN" or "BEGIN TRANSACTION" or "BEGIN WORK", and trying
> to enforce a single standard now is just going to irritate people and
> break existing applications. I vote for leaving well enough alone.
>
> > Bruce, please don't use "begin" and "end" in your book.
>
> Sure, it makes sense for the book to consistently use "BEGIN WORK"
> and "COMMIT WORK", which are probably the least likely to confuse
> novices. But I think actually removing the other variants would be
> just an exercise in causing trouble.
I don't know how Oracle or most everyone else is doing it, but Sybase
uses:
begin transaction [transaction name]
and
commit transaction [transaction name]
I don't see an end transaction in the quick ref, but they do have a:
begin
statement block
end
in there.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> Have you seen http://www.pop4.net?
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SEV | 1999-11-23 16:40:49 | AW: [HACKERS] SQL statements: begin and end |
Previous Message | Zeugswetter Andreas SEV | 1999-11-23 15:42:29 | AW: [HACKERS] SQL statements: begin and end |