Re: Eliminate information_schema from oid2name listing - Mailing list pgsql-patches

From Tom Lane
Subject Re: Eliminate information_schema from oid2name listing
Date
Msg-id 4040.1058794607@sss.pgh.pa.us
Whole thread Raw
In response to Re: Eliminate information_schema from oid2name listing  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Eliminate information_schema from oid2name listing  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Peter Eisentraut <peter_e@gmx.net> writes:
> Kenji Sugita writes:
>> This small patch eliminates relations in information_schema from oid2name
>> listing.

> Why would one want to do that?

AFAICS the point of oid2name is to provide a mapping between disk file
names and table names.  As such, what it *ought* to be doing is
suppressing views, since those don't have disk files --- they are only
cluttering the listing with irrelevant data.  If we put that in, there'd
be no need to special-case information_schema.

            regards, tom lane

pgsql-patches by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Release.sgml markup
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] pg_tables view definition incorrect??