| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | PostgreSQL General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: uncommited question |
| Date: | 2002-08-09 12:16:27 |
| Message-ID: | 20020809081627.B17048@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2002-08-09 12:24:26 | Re: handling transactions from C (libpq) |
| Previous Message | Cornelia Boenigk | 2002-08-09 11:25:14 | Re: Warning: PostgreSQL query failed: ERROR: [my_tabel]: Permission denied in [my_php_program] |