Re: pg_restore and schema's

From: Dick Kniep <dick(at)kniep(dot)nl>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_restore and schema's
Date: 2005-08-22 16:15:45
Message-ID: 200508221815.46332.dick@kniep.nl
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2005-08-22 17:59:42 Re: Query results caching?
Previous Message Robby Russell 2005-08-22 16:08:24 PL/Ruby untrusted