David E. Wheeler wrote: > On Nov 19, 2008, at 9:12 AM, Josh Berkus wrote: > > > Folks, > > > > Since it's too late to look at this for 8.4, can the following go on > > the TODO list? > > > > Referential Integrity > > > > [] Allow creation of FKs targeting unique expression indexes on the > > referenced table. Syntax: REFERENCES <reftable> ( ( column > > expression ) ) > > > > Reason: current FK rules do not allow creating FKs to columns which > > are defined as, for example, unique(lower(column)). This forces > > users to either abandon RI for that table, to store duplicate data, > > or create superfluous indexes. > > > > Hmmm ... I suppose the above would require enabling expression > > indexes for PKs as well, no? > > In 8.4 you should be able to get around this particular example using > citext.
Yes, good idea on citext. Allowing foreign keys to point to expression indexes seems to open a can of worms and I am not sure there is enough demand to warrant it. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers