Re: [HACKERS] SET AUTO TRANSACTION - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] SET AUTO TRANSACTION
Date
Msg-id 36FBCEAB.373D71C4@alumni.caltech.edu
Whole thread Raw
In response to SET AUTO TRANSACTION  (Michael Meskes <meskes@postgresql.org>)
List pgsql-hackers
> I'd like to make the automatic transaction starting of ecpg a function
> adjustable on a per connection base. My best bet is to add a variable 
> and allow something like:
> exec sql [at connection] set autotrans = 1;
> The question now is how do I name this variable? It seems to me that 
> there is not much in the standard that would limit my choice, is it?

The Ingres syntax is
 SET AUTOCOMMIT ON;

which is clearer than setting a variable. We do allow the syntax
 SET item TO value;

which is almost as clear:
 SET AUTOCOMMIT TO ON;

But I think it would be appropriate to not require quotes around a
string or an integer argument for this important option.
                      - Tom


pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] PostgreSQL LOGO (was: Developers Globe (FINAL))
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] PostgreSQL LOGO (was: Developers Globe (FINAL))