BUG #6083: psql script line numbers incorrectly count \copy data - Mailing list pgsql-bugs

From Steve Haslam
Subject BUG #6083: psql script line numbers incorrectly count \copy data
Date
Msg-id 201106291338.p5TDcPTZ012367@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #6083: psql script line numbers incorrectly count \copy data
List pgsql-bugs
The following bug has been logged online:

Bug reference:      6083
Logged by:          Steve Haslam
Email address:      araqnid@googlemail.com
PostgreSQL version: 9.0.4
Operating system:   Debian GNU/Linux (amd64)
Description:        psql script line numbers incorrectly count \copy data
Details:

test_linenumbers.dat:
1
1
2
3
5
8

test_linenumbers.sql:
DO $$ BEGIN  RAISE INFO 'Before copy';  END; $$; -- line 1
CREATE TEMP TABLE test_linenumbers_data(value int);
\copy test_linenumbers_data from test_linenumbers.dat
DO $$ BEGIN  RAISE INFO 'After copy';  END; $$; -- line 4


Performing "psql -f test_linenumbers.sql" produces:


psql:test_linenumbers.sql:1: INFO:  Before copy
DO
CREATE TABLE
psql:test_linenumbers.sql:11: INFO:  After copy
DO


However, it seems to me that the second INFO should be reported against
test_linenumbers.sql:4 rather than :11. Apparently, the data read from \copy
is incrementing the script line number counter?

Also occurs with 9.1b2 and a recent 9.2devel.

pgsql-bugs by date:

Previous
From: "Stewart Fritts"
Date:
Subject: BUG #6084: When Updating Tables with Select Into
Next
From: "Olivier LEVESQUE"
Date:
Subject: BUG #6085: pg_upgrade fails when unix_socket_directory != /tmp