I've used pgAccess to make all the tables and colums.
Ex.: table diagnosis column diagnosis_ID
Then, when I use psql to execute select statements, diagnosis_ID does
But when I change the column name to diagnosis_id it works fine.
The problem is therefore that it is possible to create a column name
with uppercase but psql transforms all statements to lowercase, and
therefore will not work.
(Sorry about my bad English)
pgsql-bugs by date
|Next:||From: Dmitry Tkach||Date: 2002-04-03 21:55:56|
|Subject: A bug in gist code with fetch/move |
|Previous:||From: Tom Lane||Date: 2002-04-03 20:22:50|
|Subject: Re: Inconsistant use of index. |