"Steve Haslam" <araq...@googlemail.com> writes: > ... Apparently, the data read from \copy > is incrementing the script line number counter?
Yeah, so it is. That is correct behavior for COPY FROM STDIN, but not so much for copying from a separate file. The attached patch seems like an appropriate fix. However, I'm unsure whether to apply it to released branches ... does anyone think this might break somebody's application? regards, tom lane
diff --git a/src/bin/psql/copy.c b/src/bin/psql/copy.c index 5e69d29b6cbeab56aa0c85e85c3edce46d06efac..ebe5ee9ea551b858a4ad6119322405109d3212d8 100644 *** a/src/bin/psql/copy.c --- b/src/bin/psql/copy.c *************** handleCopyIn(PGconn *conn, FILE *copystr *** 586,592 **** } } ! pset.lineno++; } } --- 586,593 ---- } } ! if (copystream == pset.cur_cmd_source) ! pset.lineno++; } }
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers