By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

foreign key to view colom are permitted?

P: 1
is it possible making a reference to a view item instead of a table.
I have a view named v_common and a a table named t_cave, i have to reference an item from t_cave to v_common

Oct 24 '13 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 700
I have use postgres since ages :) bus as far as I remember postgres do not support contraints on views (maybe the last 9.x version does, not sure). Can't you define proper constrain on a table that is used in view definition?
Dec 30 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.