Re: [PATCH] Make "psql -1 < file.sql" work as with "-f"

Peter Eisentraut <peter_e@gmx.net>

From: Peter Eisentraut <peter_e@gmx.net>
To: Robert Haas <robertmhaas@gmail.com>
Cc: David Fetter <david@fetter.org>, Fabien COELHO <coelho@cri.ensmp.fr>, PostgreSQL Developers <pgsql-hackers@postgresql.org>
Date: 2013-05-10T13:50:55Z
Lists: pgsql-hackers
On 8/9/12 9:08 AM, Robert Haas wrote:
> On Wed, Aug 8, 2012 at 6:50 PM, David Fetter <david@fetter.org> wrote:
>>> I'm wondering if perhaps -- in addition to what you've done here -- we
>>> should make "psql -1" error out if reading from a terminal.
>>
>> +1 for this.
> 
> OK, done.
> 
> I had to revise the original patch pretty heavily before committing;

My first use of 9.3beta1 in development failed because of changes
introduced by this patch, specifically because of the newly introduced error

    psql: -1 is incompatible with -c and -l

I'm not convinced this is correct.  -c and -l are single-transaction
actions almost by definition.

This particular aspect of the change wasn't really brought up in the
original thread.  What was your thinking?



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers