Re: Name column

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: André Fernandes <andre(dot)de(dot)camargo(dot)fernandes(at)hotmail(dot)com>, heikki(dot)linnakangas(at)enterprisedb(dot)com, arhipov(at)dc(dot)baikal(dot)ru, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Name column
Date: 2010-09-24 15:55:02
Message-ID: 21466.1285343702@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Fri, Sep 24, 2010 at 11:43 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> -1. There's nothing wrong with the function-as-a-computed-column
>> feature, and it seems likely that taking it away will break applications.

> ... What evidence do we have that anyone is relying on this
> behavior in applications? Every report I've heard of it involved
> someone being surprised that it worked that way.

So? There are lots of surprising things in SQL. And *of course* the
only complaints come from people who didn't know about it, not from
satisfied users.

The reason people don't know about this feature is that it's so poorly
documented --- there's just one mention buried deep in chapter 35 of
the manual, in a place where most people wouldn't think to look for it.
I'm not quite sure where's a better place though.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thom Brown 2010-09-24 15:59:44 Re: Enable logging requires restart
Previous Message Andrew Dunstan 2010-09-24 15:52:36 Re: Enable logging requires restart