Re: uncommited question

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