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?
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!
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