Re: Re: Query precompilation?

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: Raw Message | Whole Thread | 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
===================================================

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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