Forum OpenACS Development: acs-content-repository problem with PG 7.3

Hi all,

In oacs-4-6 we seem to have a problem with the function content_type__drop_type (and perhaps others) with PG 7.3.

This function drops the rules, views and tables associated with a certain type, but the problem is that the syntax for DROP RULE has changed in 7.3.

The function fails to drop the rule because the syntax is now "DROP RULE foo ON relation_bar [CASCADE | RESTRICT]". Cascade and restrict control weather the rule should drop all depending objects, with the default being restrict.

We can't just drop the VIEW either, unless we specified "DROP VIEW foo CASCADE" -- which would drop the rule -- but the CASCADE option is not supported in 7.2.

So should we just have a different function for 7.3 in a different section of the XQL file with the appropriate version? Are we planning to continue support for 7.2 with 7.4 almost out?

Thanks,

-Roberto

Collapse
Posted by Roberto Mello on
Argh,

Nevermind about the XQL part, the function is created as part of the -create scripts. Sorry about that.

-Roberto