BUG #13674: psql: \i from a script run through \e misparses SQL as \i arguments

From: postgresql(at)zr40(dot)nl
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13674: psql: \i from a script run through \e misparses SQL as \i arguments
Date: 2015-10-12 17:47:31
Message-ID: 20151012174731.2778.64527@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13674
Logged by: Matthijs van der Vleuten
Email address: postgresql(at)zr40(dot)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=#

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2015-10-12 23:37:42 Re: Re: [BUGS] BUG #13611: test_postmaster_connection failed (Windows, listen_addresses = '0.0.0.0' or '::')
Previous Message John Pruitt 2015-10-12 14:50:18 Re: BUG #13670: DST discrepancy between age() and subtraction for timestamptz arguments