Re: SPI_execp() failed in RI_FKey_cascade_del()
От
Stephan Szabo
Тема
Re: SPI_execp() failed in RI_FKey_cascade_del()
Дата
Msg-id
20020409110924.Y95735-100000@megazone23.bigpanda.com
Ответ на
Re: SPI_execp() failed in RI_FKey_cascade_del() (Papp, Gyozo)
Список
Дерево обсуждения
Re: SPI_execp() failed in RI_FKey_cascade_del() "Papp, Gyozo" <pgerzson@freestart.hu>
Re: SPI_execp() failed in RI_FKey_cascade_del() Stephan Szabo <sszabo@megazone23.bigpanda.com>
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.
В списке pgsql-general по дате отправления