Re: SPI_execp() failed in RI_FKey_cascade_del()

Hi,
----- Original Message -----
From: "Stephan Szabo" <sszabo@megazone23.bigpanda.com>
To: "Papp, Gyozo" <pgerzson@freestart.hu>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, April 09, 2002 8:11 PM
Subject: Re: [GENERAL] SPI_execp() failed in RI_FKey_cascade_del()


|
| 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.

So, if I drop these rules and I try to protect my database
with a right acl system (grant + revoke), it should work.

Thanks for the clarification!

--
Gyozo Papp - pgerzson@freestart.hu