Re: SPI_execp() failed in RI_FKey_cascade_del()

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Papp, Gyozo" <pgerzson(at)freestart(dot)hu>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: SPI_execp() failed in RI_FKey_cascade_del()
Date: 2002-04-09 18:11:42
Message-ID: 20020409110924.Y95735-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Tue, 9 Apr 2002, Papp, Gyozo wrote:

> Hello,
>
> You can find my minimal db scheme and data which reproduces
> this error (after pg_restore, too):
>
> http://213.134.22.60/~gerzson/spi-error.tar.gz
> (pg_dump -C Ft -f spi-error.tar and gzipped)
>
>
> Thanks for your guidance in advance
>
> ps: [to Tom Lane] sorry for the broken link

I think I see something that might be doing it...
There's a rule on answer_summary that forces deletes to be
negated which means the trigger sees that the delete wasn't
executed which would give the error since the constraint
would no longer be satisfied.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fran Fabrizio 2002-04-09 18:17:41 Re: Why does this not work? (keyword 'TEXT')
Previous Message Bruce Momjian 2002-04-09 18:02:33 Re: more about pg_toast growth