Postgres Pro
Downloads
Home   >   mailing lists

Re: [despammed] session-wide autocommit off - Mailing list pgsql-sql

From Andreas Kretschmer
Subject Re: [despammed] session-wide autocommit off
Date
Msg-id 20041130090312.GA29117@Pinguin.wug-glas.de
Whole thread Raw
In response to session-wide autocommit off  (Christoph Haller <ch@rodos.fzk.de>)
List pgsql-sql
Tree view 
am  30.11.2004, um  9:40:21 +0100 mailte Christoph Haller folgendes:
> Looks like I asked the wrong question the other day.
> How can I achieve a session-wide autocommit off?
> As it is possible inside a psql session via
> \unset AUTOCOMMIT

For psql i have a /etc/psqlrc:

\unset AUTOCOMMIT
\set AUTOCOMMIT FALSE
begin;

But this works only one transaction.



regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)              Tel. NL Heynitz:  035242/47212
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===

pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: session-wide autocommit off
Next
From: Richard Huxton
Date:
Subject: Re: grouping a many to many relation set