Thread

table data not being restored after pg_dump

PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-04-12T20:17:08Z

Patricia Holben (pholben@greatbridge.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
table data not being restored after pg_dump 

Long Description
After running the regression test suite, I perform a pg_dump, drop the db, recreate the db, use "psql -e regression <dumpfile" to reload the data but the table f_star can not be reloaded.  The error message says: ERROR:  copy: line 1, pg_atoi: error in "((1,3),(2,4))": can't parse "((1,3),(2,4))"

Sample Code


No file was uploaded with this report

Re: table data not being restored after pg_dump

Philip Warner <pjw@rhyme.com.au> — 2001-04-13T10:59:39Z

At 16:17 12/04/01 -0400, pgsql-bugs@postgresql.org wrote:
>Patricia Holben (pholben@greatbridge.com) reports a bug with a severity of 2
>The lower the number the more severe it is.
>
>Short Description
>table data not being restored after pg_dump 
...
>but the table f_star can not be reloaded.  The error message 
>says: ERROR:  copy: lin


This is a known problem (and has been for several versions). A search in
the archives for 'pg_dump f_star' would have revealed:

http://www.postgresql.org/mhonarc/pgsql-hackers/1998-10/msg00181.html
http://www.postgresql.org/mhonarc/pgsql-hackers/1997-09/msg00502.html
http://www.postgresql.org/mhonarc/pgsql-hackers/2001-03/msg01668.html

etc.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/