Re: SQL keywords are suddenly case sensitive

On 04/16/2013 02:46 PM, Lee Hachadoorian wrote:
> List,
>
> SQL seems to be behaving in a case-sensitive manner:
>
> universe=# select 1;
> ?column?
> ----------
> 1
> (1 row)
>
> universe=# SELECT 1;
> ERROR: syntax error at or near "SELECT 1"
> LINE 1: SELECT 1;
> ^
> I cannot figure out how this happened, and Google is not helping because
> all I'm getting is information about case-sensitivity in identifiers or
> in string comparison. I didn't even think this was possible, as I've
> always switched between lower case and upper case keywords, usually
> using lower case while testing and upper case to prettify scripts that I
> will be saving for reuse.

Interesting.

Does this behavior survive logging out and then back into a session?

Do you have any other client using the database that exhibits this behavior?

> Regards,
> --Lee
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com