Re: Troubleshooting SPI_execp() failed in RI_FKey_cascade_del()

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Joshua b(dot) Jore" <josh(at)greentechnologist(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Troubleshooting SPI_execp() failed in RI_FKey_cascade_del()
Date: 2002-06-12 21:44:51
Message-ID: 20020612144317.F95080-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ken Williams 2002-06-12 23:54:25 Re: automatic time zone conversion
Previous Message Bruce Momjian 2002-06-12 21:18:59 Re: Subject: bool / vacuum full bug followup part 2