Re: Case Preservation disregarding case sensitivity?

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');