Skip site navigation (1) Skip section navigation (2)

psql doesn't count lines correctly in pg_dump scripts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: psql doesn't count lines correctly in pg_dump scripts
Date: 2000-12-02 20:46:56
Message-ID: 25413.975790016@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
It appears that psql does not count COPY data lines while counting
lines in an input script.  This makes its reported line numbers
rather useless in a script such as those produced by pg_dump.

For example,

COPY tbl1 FROM stdin;
... some data lines here...
\.

COPY tbl2 FROM stdin;
... put some erroneous data here that will be rejected by input conversion...
\.

then do "\i scriptfile".

The error report will mention the second copy's line number, less the
number of lines occupied by the first table's data.

			regards, tom lane

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-12-03 18:55:49
Subject: alter table rename missing numeric type
Previous:From: Tom LaneDate: 2000-12-01 18:38:14
Subject: Re: inserting binary in a bytea field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group