| From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Alex Pilosov <alex(at)pilosoft(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_depend |
| Date: | 2001-07-18 00:47:51 |
| Message-ID: | 3B54DCB7.C201408E@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Peter Eisentraut wrote:
>
> Bruce Momjian writes:
>
> > > That was me. The point, however, was, given object id 145928, how the
> > > heck to you know what table this comes from?
> >
> > I think we will need the relid of the system table. I imagine four
> > columns:
> >
> > object relid
> > object oid
> > reference relid
> > references oid
>
I like
object relid
object oid
object name
reference relid
reference oid
and unadorned DROP doesn't drop dependent objects.
regards,
Hiroshi Inoue
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-07-18 01:49:13 | Re: pg_depend |
| Previous Message | Hiroshi Inoue | 2001-07-18 00:07:56 | Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results |