Re: PostgreSQL Gotchas

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>, Chris Travers <chris(at)travelamericas(dot)com>, Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, "Aly S(dot)P Dharshi" <aly(dot)dharshi(at)telus(dot)net>, "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL Gotchas
Date: 2005-10-17 14:39:15
Message-ID: 4353B793.8090304@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/17/2005 10:16 AM, Tom Lane wrote:

> Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
>> What is bad about leaving pg_catalog all lower case and expect everyone
>> to query the catalog quoted?
>
> The fact that it will break every nontrivial client currently in
> existence. Those quotes aren't there in the clients and we can't
> suddenly mandate them to become there. Also, that approach does not
> work for built-in functions (MAX, etc)

Ugh ... got me on the MAX part.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-10-17 14:46:40 Re: [GENERAL] Oracle buys Innobase
Previous Message Richard Huxton 2005-10-17 14:32:36 Re: Safe to kill idle connections?