Re: psql line number reporting from stdin - Mailing list pgsql-hackers

From Nathan Wagner
Subject Re: psql line number reporting from stdin
Date
Msg-id a197d0d042e4d173d94ba3b923a1148f@granicus.if.org
Whole thread Raw
In response to psql line number reporting from stdin  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Sat, 26 Nov 2011 22:36:15 +0200, Peter Eisentraut wrote:
> There is a long-standing oddity in psql that running
>
> psql -f foo.sql
>
> returns error messages with file name and line number, like
>
> psql:foo.sql:1: ERROR:  syntax error at or near "foo"
>
> but running
>
> psql < foo.sql does not.  I suggest we change the latter to print
>
> psql:<stdin>:1: ERROR:  syntax error at or near "foo"
>
> Other examples for the use of the spelling "<stdin>" in this context
> include gcc and slonik.
>
> Error messages printed in interactive mode will not be affected, of
> course.
>
> Patch attached.

No issue with the change itself, but the docs claim
that

"the variant using the shell's input redirection is
(in theory) guaranteed to yield exactly the same output
you would have received had you entered everything by hand."

-- 
nw


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCH] Replace a long chain of if's in eval_const_expressions_mutator by a switch()
Next
From: Jim Nasby
Date:
Subject: Re: strange nbtree corruption report