Re: SPI_execp() failed in RI_FKey_cascade_del()
От | Papp, Gyozo |
---|---|
Тема | Re: SPI_execp() failed in RI_FKey_cascade_del() |
Дата | |
Msg-id | 001a01c1e055$e491ffe0$01fdfea9@jaguar обсуждение исходный текст |
Ответ на | Re: SPI_execp() failed in RI_FKey_cascade_del() (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: SPI_execp() failed in RI_FKey_cascade_del()
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: