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