UPDATE Problem in PostgreSql DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • arjun417
    New Member
    • Oct 2012
    • 1

    UPDATE Problem in PostgreSql DB

    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_guided ata.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'
Working...