On 11/10/06, Sandro Dentella <[email protected]> wrote:
> Do I understad correctly that i cannot point a Foreign Key to a view? Which
> is the rationale of this?
Blame the sql standard. Foreign keys are required to reference a
table with a unique constraint, and you can't add a unique constraint
to a view. 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).
merlin
