| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | Aliomar Mariano Rego <aliomar(dot)rego(at)embrapa(dot)br>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Set autocommit to off |
| Date: | 2005-08-17 12:18:22 |
| Message-ID: | BF28A34E.C97B%sdavis2@mail.nih.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 8/17/05 4:24 AM, "Aliomar Mariano Rego" <aliomar(dot)rego(at)embrapa(dot)br> wrote:
> Does somebody knows why the Postgresql 7.4.8 or later doesn't supports
> the option "SET AUTOCOMMIT TO OFF"?
See this message:
http://archives.postgresql.org/pgsql-general/2005-07/msg00064.php
In short, server-side autocommit is not possible after 7.3, I think.
Instead, use a transaction block (BEGIN...COMMIT) or set it on the client
side like this in psql:
http://www.postgresql.org/docs/8.0/interactive/app-psql.html and search for
autocommit.
Hope that helps....
Sean
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2005-08-17 12:24:10 | Re: cobol storedprocedures |
| Previous Message | Bruno Wolff III | 2005-08-17 11:51:12 | Re: BUG #1830: Non-super-user must be able to copy from a file |