drop table and pg_proc - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject drop table and pg_proc
Date
Msg-id 20010111214210J.t-ishii@sra.co.jp
Whole thread Raw
Responses Re: drop table and pg_proc
List 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 by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: AW: Re: GiST for 7.1 !!
Next
From: mlw
Date:
Subject: Re: drop table and pg_proc