Re: [PATCH] Make "psql -1 < file.sql" work as with "-f"
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: David Fetter <david@fetter.org>
Cc: Fabien COELHO <coelho@cri.ensmp.fr>, PostgreSQL Developers <pgsql-hackers@postgresql.org>
Date: 2012-08-09T13:08:43Z
Lists: pgsql-hackers
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; the original patch assumed that it was OK to make psql -1 <file go through process_file() while having psql -1 <file still go through MainLoop() directly. This isn't a good idea, because that means that any other behavioral differences between process_file() and MainLoop() will be contingent on whether -1 is used, which is not what we want. And there is at least one such difference that matters: whether or not the file and line number get prepended when emitting error messages. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company