Re: [GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Scott Marlowe
I've seen this in the ticketing system Front Range where it sticks in nbsp into the text windows and if you copy and paste it won't work. Frustrating as all hell. On Tue, Apr 16, 2013 at 7:18 PM, Lee Hachadoorian wrote: > > On 04/16/2013 08:23 PM, Tom Lane wrote: >> >> Lee Hachadoorian writes: >

Re: [GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Lee Hachadoorian
On 04/16/2013 08:23 PM, Tom Lane wrote: Lee Hachadoorian 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 biz

Re: [GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Bruce Momjian
On Tue, Apr 16, 2013 at 08:57:02PM -0400, Lee Hachadoorian wrote: > > On 04/16/2013 08:23 PM, Tom Lane wrote: > >"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

Re: [GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Lee Hachadoorian
On 04/16/2013 08:23 PM, Tom Lane wrote: "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. No, that must have been an em

Re: [GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Tom Lane
Lee Hachadoorian 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 i

Re: [GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Adrian Klaver
On 04/16/2013 04:39 PM, Lee Hachadoorian wrote: On 04/16/2013 07:31 PM, Adrian Klaver wrote: On 04/16/2013 02:46 PM, Lee Hachadoorian wrote: Interesting. Does this behavior survive logging out and then back into a session? It survives complete restart. (This is a laptop that I use for de

Re: [GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Lee Hachadoorian
On 04/16/2013 07:34 PM, Adrian Klaver wrote: 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

Re: [GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Lee Hachadoorian
On 04/16/2013 07:31 PM, Adrian Klaver wrote: 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

Re: [GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Adrian Klaver
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 hap

Re: [GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Adrian Klaver
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 hap

[GENERAL] SQL keywords are suddenly case sensitive

2013-04-16 Thread Lee Hachadoorian
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 ge