From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | Michael Meskes <meskes(at)postgreSQL(dot)org> |
Cc: | PostgreSQL Hacker <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] SET AUTO TRANSACTION |
Date: | 1999-03-26 18:15:07 |
Message-ID: | 36FBCEAB.373D71C4@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1999-03-26 18:36:32 | Re: [HACKERS] PostgreSQL LOGO (was: Developers Globe (FINAL)) |
Previous Message | Jan Wieck | 1999-03-26 17:59:34 | Re: [HACKERS] PostgreSQL LOGO (was: Developers Globe (FINAL)) |