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