| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org, "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, Neil Conway <neilc(at)samurai(dot)com> |
| Subject: | Re: Extending System Views: proposal for 8.1/8.2 |
| Date: | 2005-01-24 17:10:18 |
| Message-ID: | 22443.1106586618@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Peter Eisentraut <peter_e(at)gmx(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-01-24 17:46:42 | pgsql: Disallow LOAD to non-superusers. |
| Previous Message | Tom Lane | 2005-01-24 17:06:54 | Re: Locale agnostic unicode text |