X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 43BEB475B47 for ; Thu, 3 Apr 2003 13:38:31 -0500 (EST) Received: from shield.pirmabanka.lv (unknown [195.114.57.4]) by postgresql.org (Postfix) with ESMTP id 2151C474E44 for ; Thu, 3 Apr 2003 13:38:30 -0500 (EST) Received: from wall2.pirmabanka.lv (wall2-pub.pirmabanka.lv [195.114.57.14]) by shield.pirmabanka.lv (8.12.9/8.12.9) with SMTP id h33IcTx0026364 for ; Thu, 3 Apr 2003 21:38:29 +0300 Received: from share.pirmabanka.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Thu, 03 Apr 2003 21:38:27 +0300 (EET DST) Received: from pc311x1.pirmabanka.lv (localhost.localdomain [127.0.0.1]) by pirmabanka.lv (8.11.6/8.11.6) with SMTP id h33IcR410101 for ; Thu, 3 Apr 2003 21:38:27 +0300 Received: (qmail 4552 invoked by uid 100); 3 Apr 2003 18:38:48 -0000 Date: Thu, 3 Apr 2003 21:38:48 +0300 From: Victor Yegorov To: chester c young Cc: "Postgres SQL" Subject: Re: auto-commit Message-ID: <20030403183848.GB1712@pirmabanka.lv> Mail-Followup-To: chester c young , "Postgres SQL" References: <20030403173439.GA1712@pirmabanka.lv> <20030403175939.94683.qmail@web12706.mail.yahoo.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="+pHx0qQiF2pBVqBT" Content-Disposition: inline In-Reply-To: <20030403175939.94683.qmail@web12706.mail.yahoo.com> User-Agent: Mutt/1.4.1i X-Spam-Status: No, hits=-28.1 required=5.0 tests=BAYES_10,IN_REP_TO,PGP_SIGNATURE_2,REFERENCES, USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/46 X-Sequence-Number: 12747 --+pHx0qQiF2pBVqBT Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * chester c young [03.04.2003 21:02]: > thanks! (duh) Take a glance at configuration (postgresql.conf), it's possible to disable auto-commit there. In that case you'll need to commit/rollback all queries (just like in Oracle). --=20 Victor Yegorov --+pHx0qQiF2pBVqBT Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+jH+42RKGLEykUDYRAidqAJ9THwtt+rF/uU9WG3mZfQWUY1sWqQCfRmVv 3Nhjd77W/jWTSNsvIeIxppU= =Oue7 -----END PGP SIGNATURE----- --+pHx0qQiF2pBVqBT--