Forum OpenACS Development: Deleting from views on Postgresql

Posted by Michael Steigman on 06/22/03 12:06 AM

I created a new bug for this error but I wanted to post to forums as well.

On installation of certain packages (in this case, ACS Reference Data, version 0.2d), I'm getting the following errors:

psql:acs-reference-create.sql:18: WARNING:  Error occurred while executing PL/pgSQL function acs_priv_hier_ins_del_tr
psql:acs-reference-create.sql:18: WARNING:  line 59 at SQL statement
psql:acs-reference-create.sql:18: ERROR:  Cannot delete from a view
	You need an unconditional ON DELETE DO INSTEAD rule

    invoked from within
"db_source_sql_file -callback $callback $path/$file_path"
    (procedure "apm_package_install_data_model" line 32)
    invoked from within

This is a 4.6.3 instance running on PG 7.3.2. I found one other related bug in bug tracker. I've started looking into rules to accomplish this but I have to believe this is a systemic issue. Has anyone else seen/dealt with this yet?

2: Re: Deleting from views on Postgresql (response to 1)

Posted by Michael Steigman on 06/23/03 05:33 AM

Figured this out with help from Dave B. I had installed from a 4.6.1 beta and the new permissions stuff, which does away with these views ended up in the 4.6-4.6.1 upgrade script. Since the upgrade script was a version beneath my "4.6.1" kernel, I never got the upgrade.

This may or may not be an issue for others but I thought I'd mention the fact that I was unable to run the 4.6-4.6.1 upgrade script on PG 7.3 without writing rules for deleting from views. So if you are planning to move a site over to 7.3 and *then* run the upgrade scripts to get to the kernel to 4.6.3, your life will be easier if you are at least at 4.6.1 before you dump your 7.2 DB.