Re: [GENERAL] pg_restore and schema's

2005-08-22 Thread Dick Kniep
Hi Michael, Yes indeed, it is 7.4.8, and I will file a bugreport. Op maandag 22 augustus 2005 15:21, schreef Michael Fuhr: > On Mon, Aug 22, 2005 at 09:30:36AM +0200, Dick Kniep wrote: > > [EMAIL PROTECTED]:/tmp> pg_restore -O -d cvix2 /tmp/dumpdb > > pg_restore: [archiver (db)] could not execute

Re: [GENERAL] pg_restore and schema's

2005-08-22 Thread Michael Fuhr
On Mon, Aug 22, 2005 at 09:30:36AM +0200, Dick Kniep wrote: > > [EMAIL PROTECTED]:/tmp> pg_restore -O -d cvix2 /tmp/dumpdb > pg_restore: [archiver (db)] could not execute query: ERROR: schema "Lindix" > does not exist What version of PostgreSQL are you using? I can duplicate this problem with

[GENERAL] pg_restore and schema's

2005-08-22 Thread Dick Kniep
Hi list, We have developed an application that makes extensive use of schema's in the database. Some of the schemanames are uppercase, some are lowercase. I make a backup using pg_dump -f /tmp/dumpdb -F c -Z 5 cvix When I try to restore this file, it fails with [EMAIL PROTECTED]:/tmp> pg_res