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? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
