Re: FK pointing to a VIEW - Mailing list pgsql-general

From Olexandr Melnyk
Subject Re: FK pointing to a VIEW
Date
Msg-id d5f60f0c0611101247s3ca31cfei48c5674ed646c775@mail.gmail.com
Whole thread Raw
In response to FK pointing to a VIEW  (Sandro Dentella <sandro@e-den.it>)
Responses Re: FK pointing to a VIEW  (Lars Heidieker <lars@merlin.de>)
List pgsql-general
> While I agree in principle that such a thing should be
> able to be done, it simply isn't possible. (in PostgreSQL, you can't
> even add an index to a view, which a unique constraint would depend
> on).

Agreed on that.

But such an extension would require a view to be more than just SELECT.

------------------------------
Olexandr Melnyk,
http://omelnyk.net/

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: Request for replication advice
Next
From: "Brendan Jurd"
Date:
Subject: Re: Request for replication advice