Search Postgresql Archives

FK pointing to a VIEW

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux