The following bug has been logged online: Bug reference: 1843 Logged by: D.J. Kniep Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.8 Operating system: Linux (SuSE 9.3) Description: pg_restore -O restores lowercase schemanaam Details:
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_restore -O -d cvix2 /tmp/dumpdb pg_restore: [archiver (db)] could not execute query: ERROR: schema "Lindix" does not exist After checking, the schema lindix does exist (Note the lowercase l), but is empty. If I turn on statement logging, I see the following when running pg_restore -O: CREATE SCHEMA Test; If I run pg_restore without -O, I see the following: CREATE SCHEMA "Test" AUTHORIZATION postgres; Off course this should be CREATE SCHEMA "Test"; ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
