Re: SQL keywords are suddenly case sensitive

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lee Hachadoorian <Lee(dot)Hachadoorian+L(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL keywords are suddenly case sensitive
Date: 2013-04-17 00:23:24
Message-ID: 13281.1366158204@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lee Hachadoorian <Lee(dot)Hachadoorian+L(at)gmail(dot)com> writes:
> 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;
> ^

That's really bizarre, but I don't think it's a case sensitivity problem
as such. Watch what I get from a syntax error on a normally-functioning
system:

$ psql
psql (9.1.9)
Type "help" for help.

regression=# select 1;
?column?
----------
1
(1 row)

regression=# SELECT 1;
?column?
----------
1
(1 row)

regression=# xELECT 1;
ERROR: syntax error at or near "xELECT"
LINE 1: xELECT 1;
^

See the differences? The error message indicates that your parser saw
"SELECT 1" as all one token. Also, if you transcribed this accurately,
it looks like the error cursor is pointing to the second character of
the "SELECT" not the first (could you confirm that?). Which is even
more bizarre. I'm not sure what's going on, but I think it's more
likely to be something to do with whitespace not being really whitespace
than it is with case as such. Consider the possibility that you're
somehow typing a non-breaking space or some such character. One thing
that might be useful is to examine the error report in the postmaster
log using an editor that will show you any non-printing characters.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Hachadoorian 2013-04-17 00:57:02 Re: SQL keywords are suddenly case sensitive
Previous Message Adrian Klaver 2013-04-16 23:46:02 Re: SQL keywords are suddenly case sensitive