Re: psql + autocommit

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: psql + autocommit
Date: 2004-09-21 03:08:03
Message-ID: 355fa78a33f16682e8805235eea600e5@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200409202307

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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2004-09-21 05:45:45 Re: Any reason not to use inheritance?
Previous Message Marc G. Fournier 2004-09-21 02:57:20 Re: using database for queuing operations?