From: Frank Bax <fbax@sympatico.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Case Preservation disregarding case sensitivity?
Date: Fri, 27 Oct 2006 21:50:22 -0400
Message-ID: <5.2.1.1.0.20061027214608.04129070@pop6.sympatico.ca> (raw)
In-Reply-To: <200610271623.37525.beauh@bluefrogmobile.com>
At 07:23 PM 10/27/06, beau hargis wrote:
>I am aware of the double-quote 'feature' which indicates that an element
>should be treated in a case-sensitive way. This as been the 'answer' to every
>question of this sort. This 'feature' does not solve the problem and
>introduces other problems.
If you use double-quotes when creating the table, you need to use
double-quotes EVERY time you access those elements. Neither of your two
examples (that produced errors) have double quotes.
>ALTER TABLE user_profile ADD CONSTRAINT fk_uproftype FOREIGN KEY
>(userProfileTypeId) REFERENCES user_profile_type (userProfileTypeId);
>
>ERROR: column "userprofiletypeid" referenced in foreign key constraint does
>not exist
>insert into user_profile_type
>(userProfileTypeId,userProfileType) VALUES(1,'ABNORMAL');
>
>ERROR: column "userprofiletypeid" of relation "user_profile_type" does not
>exist
The second query should be:
insert into user_profile_type ("userProfileTypeId","userProfileType")
VALUES(1,'ABNORMAL');
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fbax@sympatico.ca
Subject: Re: Case Preservation disregarding case sensitivity?
In-Reply-To: <5.2.1.1.0.20061027214608.04129070@pop6.sympatico.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox