Re: Case Insensitive Foreign Key Constraint

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: George Weaver <gweaver(at)shaw(dot)ca>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Case Insensitive Foreign Key Constraint
Date: 2011-01-18 17:58:47
Message-ID: AANLkTinxj8YkxFqLnB6LRUzXGzxGHNAtj-N_aHJ3+Q5T@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would probably just have a check constraint that prevented the
relevant PK field from being lower case in the first place. I had to
do that recently, but my approach reflected the business rules.

You may prefer to use citext:

http://www.postgresql.org/docs/current/interactive/citext.html

--
Regards,
Peter Geoghegan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James B. Byrne 2011-01-18 18:02:34 Getting a sample data set.
Previous Message George Weaver 2011-01-18 17:53:55 Case Insensitive Foreign Key Constraint