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

UPDATE Problem in PostgreSql DB

P: 1
warning: pg_query(): Query failed: ERROR: cannot update a view HINT: You need an unconditional ON UPDATE DO INSTEAD rule. in /home/websites/public_html/uac-dev.itechne.com/public/includes/database.pgsql.inc on line 138.
user warning: query: UPDATE uac_institution_view SET status = '2' WHERE nid = '9950' in /home/websites/public_html/uac-dev.itechne.com/public/sites/all/modules/uac/uac_inst_guidedata.module on line 56.


I created Rule as follows but it is not working.

CREATE RULE uac_ins AS ON INSERT TO uacin
DO INSTEAD UPDATE uac_institution_view SET status = '2' WHERE nid = '9950'
Oct 31 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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