BUG #13674: psql: \i from a script run through \e misparses SQL as \i arguments - Mailing list pgsql-bugs

From postgresql@zr40.nl
Subject BUG #13674: psql: \i from a script run through \e misparses SQL as \i arguments
Date
Msg-id 20151012174731.2778.64527@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13674: psql: \i from a script run through \e misparses SQL as \i arguments  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13674
Logged by:          Matthijs van der Vleuten
Email address:      postgresql@zr40.nl
PostgreSQL version: 9.4.5
Operating system:   Mac OS X
Description:

Reproduction:

1. Create file a.sql with the following contents:

BEGIN;
\i b.sql
ROLLBACK;

2. Create an empty file b.sql (smallest reproduction; bug also occurs with
non-empty files)
3. In psql, execute: \e a.sql
4. In $EDITOR, save and exit

Actual output:

~/test % psql -Xe
psql (9.4.5)
Type "help" for help.

zr40=# \e foo2.sql
BEGIN;
BEGIN
\i: extra argument "ROLLBACK;" ignored
zr40=#

Expected output:

~/test % psql -Xe
psql (9.4.5)
Type "help" for help.

zr40=# \e foo2.sql
BEGIN;
BEGIN
ROLLBACK;
ROLLBACK
zr40=#

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #13675: Problem statement “INSERT ON CONFLICT WHERE"
Next
From: Haribabu Kommi
Date:
Subject: Re: BUG #13670: DST discrepancy between age() and subtraction for timestamptz arguments