FK pointing to a VIEW - Mailing list pgsql-general

From Sandro Dentella
Subject FK pointing to a VIEW
Date
Msg-id 20061110191611.GA24084@casa.e-den.it
Whole thread Raw
Responses Re: FK pointing to a VIEW
Re: FK pointing to a VIEW
List pgsql-general
Do I understad correctly that i cannot point a Foreign Key to a view? Which
is the rationale of this?

TIA
sandro
*:-)



test=# alter table mail_inviate
test-#    add constraint mail_inviate_fk
test-#    FOREIGN KEY (mittente) REFERENCES mail_view(mail_address)
test-# ;
ERROR:  referenced relation "mail_view" is not a table

--
Sandro Dentella  *:-)
http://www.tksql.org                    TkSQL Home page - My GPL work

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Cached dataset
Next
From: "Merlin Moncure"
Date:
Subject: Re: FK pointing to a VIEW