Skip site navigation (1) Skip section navigation (2)

a problem with case in psql

From: "ystein Thorsen" <othors99(at)grm(dot)hia(dot)no>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: a problem with case in psql
Date: 2002-04-03 20:40:30
Message-ID: 000a01c1db4f$cfd77db0$0a01a8c0@valby5dt2v28f2 (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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
not exist.

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)

ystein Thorsen
Norwegian student


pgsql-bugs by date

Next:From: Dmitry TkachDate: 2002-04-03 21:55:56
Subject: A bug in gist code with fetch/move
Previous:From: Tom LaneDate: 2002-04-03 20:22:50
Subject: Re: Inconsistant use of index.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group