Skip site navigation (1) Skip section navigation (2)

8.1beta1: pg_dumpall -c does delete from pg_shadow?

From: mark(at)mark(dot)mielke(dot)cc
To: pgsql-hackers(at)postgresql(dot)org
Subject: 8.1beta1: pg_dumpall -c does delete from pg_shadow?
Date: 2005-08-28 04:35:06
Message-ID: 20050828043506.GA19141@mark.mielke.cc (view raw or flat)
Thread:
Lists: pgsql-hackers
Hey all.

Playing around, and pg_dumpall -c does delete from pg_shadow as
part of the role cleanup?

Our friendly psql complains that pg_shadow is a view:

    psql:<filename>:11: ERROR:  cannot delete from a view
    HINT:  You need an unconditional ON DELETE DO INSTEAD rule.

And then:

    psql:<filename>:13: ERROR:  role "<role1>" already exists
    psql:<filename>:14: ERROR:  role "<role2>" already exists
    psql:<filename>:15: ERROR:  role "<role3>" already exists

I assume this is easily reproduceable for others...

Cheers,
mark

-- 
mark(at)mielke(dot)cc / markm(at)ncf(dot)ca / markm(at)nortel(dot)com     __________________________
.  .  _  ._  . .   .__    .  . ._. .__ .   . . .__  | Neighbourhood Coder
|\/| |_| |_| |/    |_     |\/|  |  |_  |   |/  |_   | 
|  | | | | \ | \   |__ .  |  | .|. |__ |__ | \ |__  | Ottawa, Ontario, Canada

  One ring to rule them all, one ring to find them, one ring to bring them all
                       and in the darkness bind them...

                           http://mark.mielke.cc/


Responses

pgsql-hackers by date

Next:From: ohpDate: 2005-08-28 13:16:51
Subject: timestamp.c
Previous:From: Chris BrowneDate: 2005-08-28 03:49:41
Subject: Re: Call for 7.5 feature completion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group