Terrific, thanks for that. I'd figured out the first trick you
suggested, but the second is much clearer.
-Steve
On 6 Jul 2009, at 12:28, Dimitri Fontaine wrote:
Steve Purcell writes:
# su - postgres -c "env PGCLUSTER=8.3/main pg_dump openx|env
PGCLUSTER=8.4/main pg_
On 5 Jul 2009, at 17:55, Tom Lane wrote:
"Steve Purcell" 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_
The following bug has been logged online:
Bug reference: 4901
Logged by: Steve Purcell
Email address: st...@sanityinc.com
PostgreSQL version: 8.4.0
Operating system: Linux (Debian Unstable)
Description:Column name "window" breaks pg_dump/pg_restore
Details
