pg_dumpall (7.3) 'public' schema bug - Mailing list pgsql-bugs

From Karl O. Pinc
Subject pg_dumpall (7.3) 'public' schema bug
Date
Msg-id 20041115101751.H21241@mofo.meme.com
Whole thread Raw
Responses Re: pg_dumpall (7.3) 'public' schema bug
List pgsql-bugs
Hi,

Went to upgrade from postgresql (RedHat's postgresql
rh-postgresql-7.3.6-7) to Fedora core 3 postgresql
7.4.6-1 and encountered a problem.  If nothing else this
is worth a note on the 7.4 upgrade doc page.

I deleted the 'public' schema from my databases
in 7.3, now in 7.4 they are back.  I suppose it is remotely
possible that I really didn't delete 'public' in 7.3,
I can't recall the last time I looked, but I'm sure
I must have checked at the time I deleted public.

Ran pg_dumpall on 7.3.  After feeding the ouput to psql
on 7.4 I got:

$ psql babase
Welcome to psql 7.4.6, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
         \h for help with SQL commands
         \? for help on internal slash commands
         \g or terminate with semicolon to execute query
         \q to quit

babase=> select * from pg_namespace;
        nspname       | nspowner
|
nspacl

--------------------+----------+---------------------------------------------------------------------------------------------------------------
   pg_toast           |        1 |  pg_temp_1          |        1 |
pg_catalog         |        1 | {postgres=U*C*/postgres,=U/postgres}
   public             |        1 | {postgres=U*C*/postgres,=UC/postgres}
   information_schema |        1 | {postgres=U*C*/postgres,=U/postgres}
   babase             |      100 |
{babase_admin=U*C*/babase_admin,"group
babase_editors=U/babase_admin","group babase_readers=U/babase_admin"}
   sandbox            |      100 |
{babase_admin=U*C*/babase_admin,"group
babase_editors=UC/babase_admin","group babase_readers=U/babase_admin"}
(7 rows)


Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                   -- Robert A. Heinlein

pgsql-bugs by date:

Previous
From: Simon Riggs
Date:
Subject: Re: BUG #1320: 7.3.8 server RPM has file error
Next
From: "Karl O. Pinc"
Date:
Subject: pg_dumpall (7.3) two search_path schema bugs