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?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: Call for 7.5 feature completion
Следующее
От: ohp@pyrenet.fr
Дата:
Сообщение: timestamp.c