Re: Functions used in index definitions shouldn't be changed

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, Antonin Houska <ah(at)cybertec(dot)at>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Functions used in index definitions shouldn't be changed
Date: 2014-11-20 19:36:17
Message-ID: 546E42B1.3010108@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 11/20/2014 02:28 PM, Tom Lane wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> On Thu, Nov 20, 2014 at 1:56 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
>>> I don't think that there is a universally compelling right or wrong to
>>> questions like this, it is more a matter of taste. Is it more important to protect
>>> the casual DBA from hurting himself or herself, or is it more important to
>>> provide a well honed scalpel for the experienced surgeon?
>> +1.
>> I think if we had an already-existing prohibition here and you
>> proposed relaxing it, the howls would be equally loud. We're not
>> entirely consistent about how picky we are.
> How's that quote about foolish consistency go? In many cases, the reason
> why we enforce some things and not others is practical utility.

Right.

(FTR, the quote from Emerson goes "A foolish consistency is the
hobgoblin of little minds, adored by little statesmen and philosophers
and divines.")

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2014-11-20 20:00:51 Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Previous Message Tom Lane 2014-11-20 19:28:35 Re: Functions used in index definitions shouldn't be changed