| 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.
| 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 |