| From: | Brijesh Shrivastav <Bshrivastav(at)esri(dot)com> |
|---|---|
| To: | PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org> |
| Subject: | Re: Libpq and transactions |
| Date: | 2004-07-07 16:28:47 |
| Message-ID: | 491DC5F3D279CD4EB4B157DDD62237F404E27F00@zipwire.esri.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
Thanks for clarification! I got confused with document wording.
Brijesh Shrivastav
-----Original Message-----
From: Tomasz Myrta [mailto:jasiek(at)klaster(dot)net]
Sent: Wednesday, July 07, 2004 12:05 AM
To: Brijesh Shrivastav
Cc: PostgreSQL Interfaces
Subject: Re: [INTERFACES] Libpq and transactions
On 2004-07-07 01:50, Użytkownik Brijesh Shrivastav napisał:
> Hi!
>
> I have a question about how transaction behaves in libpq library.
> It is very clear in doc that PQexec treats each command (which could
> comprise of more than one sql command) as a single transactions.
Not exactly. PQexec treats each command as a single transaction only
when you don't add "begin" before your query. If you add "begin" before
first query - it will finish after "commit" or "rollback".
Regards,
Tomasz Myrta
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | L J Bayuk | 2004-07-08 01:12:44 | Re: pgin.tcl pg_exec_prepared slow (was: Released...) |
| Previous Message | Tomasz Myrta | 2004-07-07 07:05:20 | Re: Libpq and transactions |