Forum OpenACS Development: Re: Re: Re: Re: Re: Re: Deadlock / ShareLock fix!

Collapse
Posted by Derick Leony on
The patch worked great for one of our development instances with PG8.0.

I tried to modify the SQL script in order to apply the patch on PG 7.4.7 but since the "new" object of the rule can't be sent as a parameter the functions have to be generated with a parameter per column. This led to another problem because there are some revision views (e.g. as_sessionsi) with more than 32 attributes and 32 is the parameter limit for PG functions.

So, the chosen approach was to apply this change to every view with 32 or less attributes. Any advice will be really appreciated, though I think upgrading to PG8.1 would be the best to do :)