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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
