I have posted this in quite a few places in the past without
response, so I'll try it here once. I am not on the list, so please
send any responses to me directly. This is a minor bug that
has continued through the latest release.

--------------------------------------------

This is a small bug in pg_dump that persists.

Say you want to have an text field with the contents
of "\Help\\" (not including the quotes).

If you do the following dialog:

createdb tempdb
psql tempdb
tempdb=>create table "testtable" ( "content" character(32));
tempdb=>insert into "testtable" values ('\\Help\\\\');
tempdb=>select * from testtable;

content
---------------------------------------
\Help\\

Up to this point, everything is cool. But now if you do the following:

pg_dump -d tempdb

You will see that the insert statement it generates is now invalid:

INSERT INTO "testtable" values ('\Help\\            ');

pg_dump needs to convert a single backslash to a double backslash
in order to be able to reload again as input to pgsql.

Am I missing something? Thanks for taking a look at this. I have posted
this to the list a few times without response and you seem to want to
get everything nailed down (Thanks!) so I thought I'd try you. If you want
me to send this somewhere else, please let me know.

Thanks for all you are doing with this great database.





Fri, 8 Jan 1999 16:19:49 -0500
"Frank Morton" <fmorton@base2inc.com>
Minor Persistent Bug In pg_dump