On 4 January 2012 19:14, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Dick Visser <visser@xxxxxxxxxx> writes: >> Running pg on Ubuntu 10.04 64bit, which is 8.4.9 today. >> When I do a pg_dump using --column-inserts, the subsequent restore fails: > > Ugh ... I think I broke this :-(. > > As a workaround, you can ask pg_restore for plain text output and > pipe that to psql. Pfew, that worked, I actually didn't know about this SQL mode of pg_restore. At least my backups are not useless :-) -- Dick Visser System & Networking Engineer TERENA Secretariat Singel 468 D, 1017 AW Amsterdam The Netherlands -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin