Re: Autocommit off in psql??

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: Raw Message | Whole Thread | 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?
>

In response to

Browse pgsql-general by date

  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