Re: pg_depend

Bruce Momjian wrote:
> 
> > I like
> >       object relid
> >       object oid
> >       object name
> >       reference relid
> >       reference oid
> 
> Can I ask why you like the object name?
> 

Oops I made a mistake.
Reference name is needed not an object name,
i.eobject relidobject oidrelerence relidreference oidreference name
create table a (...);create view view_a as select .. from a;

Then we have an pg_depend entry e.g.
pg_class_relidoid of the view_apg_class_relidoid of the table a'a' the name of the table

and so on.
drop table a; (unadorned drop).

Then the above entry would be changed to
pg_class_relid(unchanged)oid of the view_s(unchagned)pg_class_relid(unchanged)InvalidOid'a' the name of the
table(unchanged)
create table a (...);

Then the pg_depend entry would be
pg_class_relid(unchanged)oid of the view_s(unchagned)pg_class_relid(unchanged)the oid of the new table a'a' the name of
thetable(unchanged)
 

regards,
Hiroshi Inoue