Re: PostgreSQL Gotchas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
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:16:59
Message-ID: 22146.1129558619@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Hallgren 2005-10-17 14:17:50 Re: Oracle buys Innobase
Previous Message Jan Wieck 2005-10-17 14:07:22 Re: PostgreSQL Gotchas