On 11/10/06, Sandro Dentella <sandro@xxxxxxxx> 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
