Thanks for the quick reply, Tom. That makes sense, and yes, that does
appear to be the problem.
I thought that I *was* using the newer pg_dump, but I'm doing this on
Debian:
# su - postgres -c "env PGCLUSTER=8.3/main pg_dump openx|env
PGCLUSTER=8.4/main pg_restore -d template1 -C"
And the debian pg_wrapper script ends up selecting the 8.3 pg_dump
binary in the first case. I'll have to figure out if there's even a
way to execute the newer pg_dump against the old database, which I
expect to be fiddly.
Thanks again, and sorry for the noise.
-Steve
On 5 Jul 2009, at 17:55, Tom Lane wrote:
"Steve Purcell" <st...@sanityinc.com> writes:
The DB schema for openx (openx.org) contains a table with a column
called
"window", which now causes a syntax error if unquoted. pg_dump
doesn't
quote the column, so pg_restore/psql fail on the pg_dump output.
This is one of the reasons why it's recommended that you use the later
version's pg_dump to perform a cross-version dump and restore. 8.4's
pg_dump knows that "window" is a reserved word, but 8.3's could hardly
be expected to.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
