Re: pg_depend - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: pg_depend
Date
Msg-id Pine.LNX.4.30.0107171458100.678-100000@peter.localdomain
Whole thread Raw
In response to Re: pg_depend  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: pg_depend
List pgsql-hackers
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'm not seeing the point.  You're essentially duplicating the information
that's already available in the system catalogs.  This is bound to become
a catastrophe the minute a user steps in and does manual surgery on some
catalog.  (And yes, manual surgery should still be possible.)

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: Re: SOMAXCONN (was Re: Solaris source code)
Next
From: Luis Sousa
Date:
Subject: Operator *=