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: > > postgres@linux:/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 7.4.8, but only with pg_restore's -O option. 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; > > Since identifiers must be quoted to preserve case, I'd say the -O > behavior is a bug. You might wish to report this to pgsql-bugs. > > I tested 8.0.3 and it doesn't have this problem. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
