Re: [HACKERS] BEGIN vs START TRANSACTION

2003-10-27 Thread Neil Conway 
On Sun, 2003-10-26 at 19:22, Gaetano Mendola wrote:
 Hi all,
 why START TRANSACTION READ ONLY is allowed
 and not BEGIN READ ONLY ?

As Chris KL points out, it's not required by the standard (since BEGIN
isn't part of the standard to begin with). I suppose we could add it,
but it seems a little pointless -- BEGIN ; SET ... seems just as good.

-Neil



---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [HACKERS] BEGIN vs START TRANSACTION

2003-10-27 Thread Gaetano Mendola 
Christopher Kings-Lynne wrote:
 I think because START TRANSACTION is SQL standard?   However, I thought
 BEGIN WORK was SQL standard, and we don't support READ ONLY there
 either --- hmmm.


 BEGIN is no part of the SQL standard.  The only way to begin a
 transaction under the SQL standard is START TRANSACTION.
These IMHO means push people to not use BEGIN anymore.

Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly

Re: [HACKERS] BEGIN vs START TRANSACTION

2003-10-26 Thread Bruce Momjian 
Gaetano Mendola wrote:
 Hi all,
 why START TRANSACTION READ ONLY is allowed
 and not BEGIN READ ONLY ?

I think because START TRANSACTION is SQL standard?   However, I thought
BEGIN WORK was SQL standard, and we don't support READ ONLY there
either --- hmmm.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [HACKERS] BEGIN vs START TRANSACTION

2003-10-26 Thread Christopher Kings-Lynne 
I think because START TRANSACTION is SQL standard?   However, I thought
BEGIN WORK was SQL standard, and we don't support READ ONLY there
either --- hmmm.
BEGIN is no part of the SQL standard.  The only way to begin a 
transaction under the SQL standard is START TRANSACTION.

Chris



---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings