Re: [BUGS] Case bug in SQL Constraint

2002-08-02 Thread Stephan Szabo
On Thu, 1 Aug 2002, Warren W. Gay VE3WWG wrote: > The SQL query below reports an error if the value "uid" is > provided in uppercase ("UID"). The error reported is: > > ERROR: CREATE TABLE: column "UID" named in key does not exist > > The problem is eliminated if "UID" is made "uid". > Here is

[BUGS] Case bug in SQL Constraint

2002-08-02 Thread Warren W. Gay VE3WWG
The SQL query below reports an error if the value "uid" is provided in uppercase ("UID"). The error reported is: ERROR: CREATE TABLE: column "UID" named in key does not exist The problem is eliminated if "UID" is made "uid". Here is the full text of the query: CREATE TABLE PASSWD ( NAME