| From: | "Simon Crute" <simon-news(at)nospam(dot)geordie(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Autocommit off in psql?? |
| Date: | 2001-05-23 18:24:27 |
| Message-ID: | 990642484.21570.0.nnrp-09.9e981bad@news.demon.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'd like to seccond a request for that kind of feature if it isn't already
available.
If it is available, how do I set it up ?
""Tim Mickol"" <tmickol(at)combimatrix(dot)com> wrote in message
news:NCEEJEAEIDNFKBMALPGMOEIMCCAA(dot)tmickol(at)combimatrix(dot)com(dot)(dot)(dot)
> Actually, I think the original question alluded to SQL*PLUS behavior that
> allows one to disable autocommit for an ENTIRE session,
> not simply a discrete transaction. In psql, in order to enforce
> autocommit=off for an entire session, you must repeatedly issue a series
of
> BEGIN directives, one following each ROLLBACK, COMMIT, or ABORT, yes?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-05-23 18:32:45 | Re: Why can't I do this (setup question) |
| Previous Message | Hector Morales | 2001-05-23 18:23:06 | problem with buffer in psql |