8.1beta1: pg_dumpall -c does delete from pg_shadow?
От | mark@mark.mielke.cc |
---|---|
Тема | 8.1beta1: pg_dumpall -c does delete from pg_shadow? |
Дата | |
Msg-id | 20050828043506.GA19141@mark.mielke.cc обсуждение исходный текст |
Ответы |
Re: 8.1beta1: pg_dumpall -c does delete from pg_shadow?
|
Список | 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@mielke.cc / markm@ncf.ca / markm@nortel.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 bindthem... http://mark.mielke.cc/
В списке pgsql-hackers по дате отправления: