Thread: table data not being restored after pg_dump
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
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 |/