Re: psql + autocommit - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: psql + autocommit
Date
Msg-id 355fa78a33f16682e8805235eea600e5@biglumber.com
Whole thread Raw
In response to Re: psql + autocommit  (John Sidney-Woollett <johnsw@wardbrook.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Here is another way to do it:

1. Rename your system psql to something else:

mv psql real_psql

2. Make a new "psql" that is really an excutable script:

real_psql --set AUTOCOMMIT=OFF $@

Now anyone calling "psql" gets autocommit off, no matter who
they are.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200409202307

-----BEGIN PGP SIGNATURE-----

iD8DBQFBT5sevJuQZxSWSsgRAkZvAKCU16jcZfy0TLPHiKUpUYehPTBfLgCdH44t
McArsrxV+NaP8h8Q1vMLpng=
=ZO2G
-----END PGP SIGNATURE-----



pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: using database for queuing operations?
Next
From: David Garamond
Date:
Subject: Re: Any reason not to use inheritance?