Re: TODO list request: FK to unique expression indexes

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.

Best,

David