| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, Rasmus Resen Amossen <rresena(at)hotmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Postgres config file: autocommit = off |
| Date: | 2003-06-02 18:52:53 |
| Message-ID: | 10425.1054579973@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-06-02 18:53:12 | Re: Logging (was Re: Suggestion GRANT ALTER, TRIGGER ON ALTER) |
| Previous Message | Bruce Momjian | 2003-06-02 18:52:22 | Re: [GENERAL] ERROR: Memory exhausted in AllocSetAlloc(188) |