Re: BUG #4901: Column name "window" breaks pg_dump/pg_restore

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" <steve(at)sanityinc(dot)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
>