Re: Lost Trigger(s)?

On Thu, 22 Mar 2001, Rod Taylor wrote:

> delete from user;  <-- Simplest test case.  Any deletion request fails
> on this table.
> ERROR:  SPI_execp() failed in RI_FKey_cascade_del()

Hmm, that error should probably include the constraint name for the
constraint that failed.

> There are a ton of cascaded deletes that should occur from the above
> deletion.  Which one is failing -- how do I tell (can't seem to do any
> kind of comparison against bytea fields otherwise I'd try to fish out
> the 'table' entites as a start)?

I'm not sure if they'll show up, but -d2 might give you more information
(showing the queries being run).

Can you create a smaller test case that exhibits the behavior?  My
first guess would be that one of the parameters being passed to SPI_execp
got screwed up, but I'm not sure.