TODO list request: FK to unique expression indexes - Mailing list pgsql-hackers

From Josh Berkus
Subject TODO list request: FK to unique expression indexes
Date
Msg-id 49244913.20208@agliodbs.com
Whole thread Raw
Responses Re: TODO list request: FK to unique expression indexes  ("David E. Wheeler" <david@kineticode.com>)
List 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


pgsql-hackers by date:

Previous
From: "Ibrar Ahmed"
Date:
Subject: Re: New bug
Next
From: Gregory Stark
Date:
Subject: Re: New bug