On 11-07-28 09:41 AM, Tom Lane wrote:
Adrian Klaver<adrian.klaver@xxxxxxxxx> writes:
On Wednesday, July 27, 2011 9:19:38 pm Nigel Heron wrote:
I'm trying to restore a backup into a database with a new name
It doesn't work .. pg_restore claims to be creating tables, indexes,
etc. and there are no errors in the output. It only takes a few seconds
to run (the file is ~250MB).
You running the pg_restore as postgres user with sufficient privileges?
yes, i'm running it as the postgres superuser
I'm wondering if it could be the same bug reported two days ago:
http://archives.postgresql.org/message-id/201107270042.22427.julian@xxxxxxxxxx
Have you got standard_conforming_strings turned on?
regards, tom lane
That must be it! I do have standard_conforming_strings on. What i found
is a string ending with a backslash as a default in a column definition
.. so that bug must be more wide spread than just comments.
eg.
CREATE TABLE foo ( bar text DEFAULT '.\somepath\' );
thanks,
-nigel.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
