Bruce Momjian <[EMAIL PROTECTED]> writes: > SET autocommit to 'off' is going away in 7.4 so the SET USER command > will not work anymore in that release, and I can't think of a > workaround. There will be interface-specific settings, I assume, but I > am not sure how that would be controlled per-user.
As I was just telling some Red Hat cohorts, I intend to provide autocommit support in psql for 7.4 --- probably controlled by a psql variable, though I've not gotten round to designing the details yet. In any case it will be possible to turn autocommit off in your ~/.psqlrc file if you have the desire to do so. I would also say that the setting will not apply to psql -c invocations, thus avoiding the worst effects for scripts ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly