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?

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!

Mon, 22 Mar 1999 19:53:47 +0100
Michael Meskes <meskes@postgresql.org>
SET AUTO TRANSACTION
> 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

Fri, 26 Mar 1999 18:15:07 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: [HACKERS] SET AUTO TRANSACTION