Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_restore and schema's

pg_restore and schema's

From
Dick Kniep
Date:
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

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 am I doing wrong, or is it a bug. After the restore the database does
contain the schema's but all in lowercase.

Hope someone knows what to do!

Cheers,
Dick Kniep

Re: pg_restore and schema's

From
Michael Fuhr
Date:
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.

--
Michael Fuhr

Re: pg_restore and schema's

From
Dick Kniep
Date:
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.