Re: Case Preservation disregarding case sensitivity? - Mailing list pgsql-sql

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