From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Alex Pilosov <alex(at)pilosoft(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_depend |
Date: | 2001-07-18 02:25:10 |
Message-ID: | 3B54F386.A3767EF9@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.e
object relid
object oid
relerence relid
reference oid
reference name
create table a (...);
create view view_a as select .. from a;
Then we have an pg_depend entry e.g.
pg_class_relid
oid of the view_a
pg_class_relid
oid 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 the table(unchanged)
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-07-18 02:29:54 | Re: pg_depend |
Previous Message | Bruce Momjian | 2001-07-18 02:13:22 | MySQL Gemini code |