Re: Troubleshooting SPI_execp() failed in RI_FKey_cascade_del() - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Troubleshooting SPI_execp() failed in RI_FKey_cascade_del()
Date
Msg-id 20020612144317.F95080-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Troubleshooting SPI_execp() failed in RI_FKey_cascade_del()  ("Joshua b. Jore" <josh@greentechnologist.org>)
List pgsql-general
On Wed, 12 Jun 2002, Joshua b. Jore wrote:

> I found the function in src/backend/utils/adt/ri_triggers.c. A previous
> note in the archives says it might be an invalid SPI command/statement. So
> how do I debug that? Which traces ought to be turned on?

Turn on query logging probably is the first step.  A common cause of this
would be if there's a rule that might be rewriting the query to something
else (for cascade_del I'd guess that'd be a delete rule on the foreign
key table).



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Subject: bool / vacuum full bug followup part 2
Next
From: "Joshua b. Jore"
Date:
Subject: Re: Troubleshooting SPI_execp() failed in RI_FKey_cascade_del()