On Fri, 22 Aug 2003, Josh Berkus wrote:
> Guys:
>
> > Contributing could be that the table holding the deleted records is a child
> > table with an "ON CASCADE DELETE" of one of the tables being updated
> > elsewhere in the function. And the function works if called by the owner of
> > the table (and the function).
>
> Further update: I tried changing the owner of the function and table to no
> avail. Also tried dropping the FK. It seems to work if called by the
> owner of the database, but not otherwise.
It still failed after you dropped the FK (I'd have otherwise agreed with
Tom that there were some cases that I think were broken as recently as
7.3.x for some value of x on permissions)? How much of the definitions
can you let us see?