Forum OpenACS Development: Response to Weird error invoking a plpgsql function (content_revision__delete)

Unfortunately, it doesn't look like we're going to get a fix anytime soon.

Here's the response that I got from Stephan Szabo:

> It should be fixed at some point.  I'm not 100% sure what's 
> going to be involved, I'm planning on looking at this for the
> deferred state anyway.  I was hoping that one of the hackers
> would read my proposed solution and tell me if they thought it
> was a good idea.
>
> However, this may actually technically be an error case if 
> the function runs as one statement.  I've got to figure out 
> the triggered data change stuff in SQL99. :(

Here's the thread where I described the bug and Stephan responded. Unfortunately, this is way over my head, so if someone with more experience understands what is going on, feel free to jump in!

I also found another (more minor) bug in pg 7.1.2 which I mentioned earlier to Dan. That has been fixed in 7.2 (in development) and will be fixed in 7.1.3, if they decide to put out another 7.1.x release. So, for the moment, we should just work around it.