Re: table data not being restored after pg_dump - Mailing list pgsql-bugs

From Philip Warner
Subject Re: table data not being restored after pg_dump
Date
Msg-id 3.0.5.32.20010413205939.02318100@mail.rhyme.com.au
Whole thread Raw
In response to table data not being restored after pg_dump  (pgsql-bugs@postgresql.org)
List pgsql-bugs
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   |/

pgsql-bugs by date:

Previous
From: Lamar Owen
Date:
Subject: Re: postgresql-7.0.3.tar.gz != postgresql-7.0.3-2.src.rpm
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: bug in 7.0.3 related to triggers and field rename