TODO list request: FK to unique expression indexes

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: TODO list request: FK to unique expression indexes
Date: 2008-11-19 17:12:51
Message-ID: 49244913.20208@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

--Josh Berkus

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2008-11-19 17:52:01 Re: New bug
Previous Message Ibrar Ahmed 2008-11-19 17:11:45 Re: New bug