Re: PostgreSQL Gotchas - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL Gotchas
Date
Msg-id 22146.1129558619@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL Gotchas  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: PostgreSQL Gotchas
List pgsql-general
Jan Wieck <JanWieck@Yahoo.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

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: PostgreSQL Gotchas
Next
From: Richard Huxton
Date:
Subject: Re: Safe to kill idle connections?