drop table and pg_proc

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема drop table and pg_proc
Дата
Msg-id 20010111214210J.t-ishii@sra.co.jp
обсуждение исходный текст
Ответы Re: drop table and pg_proc  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Suppose a function using table t1 as its argument:

create table t1(...
create fuction f1(t1) returns...

And if I drop t1 then do pg_dump, I would got something like:
failed sanity check, type with oid 1905168 was not found

This is because the type t1 does not exist anynmore. Since not being
able to make a back up of database is a critical problem, I think we
have to fix this.

1) remove that proc entry from pg_proc if t1 is deleted

2) fix pg_dump so that it ignores sunch a bogus entry

3) do both 1) and 2)

Comments?
--
Tatsuo Ishii


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: AW: Re: GiST for 7.1 !!
Следующее
От: mlw
Дата:
Сообщение: Re: drop table and pg_proc