Re: Postgres config file: autocommit = off - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Postgres config file: autocommit = off
Date
Msg-id 10425.1054579973@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres config file: autocommit = off  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> In thinking about it, I don't see how we can ignore .psqlrc if it has
> autocommit set to off.  Imagine I am in psql and I do '\i file', and it
> works, so I code up psql -c in a script, and it doesn't work --- would
> be quite strange.

What's your point?  "psql -c '\i file'" doesn't work either.

Surely you don't want to have to put back all those SET AUTOCOMMITs again.
Yeah, it's a bit warty, but psql -c is inherently different from a psql
script.  IMHO it's not reasonable to make (shell) scripts using psql -c
have to explicitly state the obvious, which is that they'd like their
command committed.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Logging (was Re: Suggestion GRANT ALTER, TRIGGER ON ALTER)
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] ERROR: Memory exhausted in AllocSetAlloc(188)