Re: uncommited question - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: uncommited question
Date
Msg-id 20020809081627.B17048@mail.libertyrms.com
Whole thread Raw
In response to uncommited question  (Rob Brown-Bayliss <rob@zoism.org>)
List pgsql-general
On Fri, Aug 09, 2002 at 01:58:29PM +1200, Rob Brown-Bayliss wrote:
>
> Hi.
>
> What happens if I don't do any commits on a connection?
>
> I am opening a connection and doing a few "selects" from the connection.

It depends entirely on whether you issued an explicit BEGIN (this
includes "turning autocommit off").  If you did, then certain kinds
of locks will be impossible until you COMMIT.

A
--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: am@fx.ro
Date:
Subject: handling transactions from C (libpq)
Next
From: Andrew Sullivan
Date:
Subject: Re: handling transactions from C (libpq)