| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Rod Taylor <rod(dot)taylor(at)inquent(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Lost Trigger(s)? |
| Date: | 2001-03-23 16:21:21 |
| Message-ID: | Pine.BSF.4.21.0103230814500.46459-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Wilson | 2001-03-23 16:28:39 | Alter column length |
| Previous Message | Stephan Szabo | 2001-03-23 16:12:59 | Re: from string to table...? |