Re: Extending System Views: proposal for 8.1/8.2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Extending System Views: proposal for 8.1/8.2
Date
Msg-id 22443.1106586618@sss.pgh.pa.us
Whole thread Raw
In response to Re: Extending System Views: proposal for 8.1/8.2  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Marc G. Fournier wrote:
>> I may be missing something here, but haven't we always stated that
>> using 'SELECT *' should be frown'd upon for the most part?

> No, we have never stated that.

We do however point out in the docs that SELECT * is vulnerable to
addition of columns, eg footnote 1 here:
http://www.postgresql.org/docs/8.0/static/tutorial-select.html

We've always felt free to add columns to system catalogs at need,
and I don't see that adding some to system views is worse.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Locale agnostic unicode text
Next
From: Devrim GUNDUZ
Date:
Subject: Re: [COMMITTERS] pgsql: Disallow LOAD to non-superusers.