| From: | Mario Weilguni <mweilguni(at)sime(dot)com> | 
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Re: Re: Query precompilation? | 
| Date: | 2001-02-27 21:37:46 | 
| Message-ID: | 01022722374602.06354@wotan | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general pgsql-hackers | 
Hi!
Thanks for the answer, but that's not disabling autocommit, it committing by 
hand. What I mean ist Oracle-behaviour --> everthing is a transaction and 
must be commited by "COMMIT". What I ment was something like "SET autocommit 
to OFF" or something like this.
Anyway, thanks for your answer, now I know it's not possible.
Ciao,
         Mario
Am Dienstag, 27. Februar 2001 22:29 schrieben Sie:
> Mario,
>
> > This sounds nice, but I've read a lot of postgres documents and still do
> > not know how to disable autocommit. Is this possible? And how?
>
> Yes, you can disable autocommit.  All you have to do is wrap your SQL
> statements within an explicit BEGIN ... COMMIT block.
>
> Regards, Joe
>
> --
> Joe Mitchell                      joe(dot)mitchell(at)greatbridge(dot)com
> Knowledge Engineer                757.233.5567 voice
> Great Bridge, LLC                 757.233.5555 fax
> www.greatbridge.com
----------------------------------------
Content-Type: text/html; charset="us-ascii"; name="Anhang: 1"
Content-Transfer-Encoding: 7bit
Content-Description: 
----------------------------------------
-- 
===================================================
 Mario Weilguni                               KPNQwest Austria GmbH
 Senior Engineer Web Solutions                         Nikolaiplatz 4
 tel: +43-316-813824                                8020 graz, austria
 fax: +43-316-813824-26                    http://www.kpnqwest.at
 e-mail: mario(dot)weilguni(at)kpnqwest(dot)com
===================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dominic J. Eidson | 2001-02-27 21:56:47 | Re: Re: Query precompilation? | 
| Previous Message | Mitch Vincent | 2001-02-27 21:36:28 | Re: Query precompilation? - Off topic | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dominic J. Eidson | 2001-02-27 21:56:47 | Re: Re: Query precompilation? | 
| Previous Message | Mitch Vincent | 2001-02-27 21:36:28 | Re: Query precompilation? - Off topic |