SPI_execp() failed in RI_FKey_cascade_del() - Mailing list pgsql-php

From Papp, Gyozo
Subject SPI_execp() failed in RI_FKey_cascade_del()
Date
Msg-id 007801c1dfab$9070d580$01fdfea9@jaguar
Whole thread Raw
List pgsql-php
Hi,

does anyone know what this error message refers to?

PostgreSQL query failed: ERROR: SPI_execp() failed in RI_FKey_cascade_del()

The $query was "DELETE FROM request WHERE request_id=33 AND label='DEMO2';"

I have a couple of tables (about 5) that refers to table "request"
with a foreign key constraint like:

 request_id INTEGER
  CONSTRAINT n_request_id NOT NULL
  CONSTRAINT f_request_id
   REFERENCES request ON DELETE CASCADE
   DEFERRABLE INITIALLY DEFERRED,

Can i work around this without recreate the schema and not delete
correponding values from respective tables one by one?



Papp Gyozo
- pgerzson@freestart.hu


pgsql-php by date:

Previous
From: John Starkey
Date:
Subject: Greek/PHP/PostgreSQL
Next
From: "Areski Belaid"
Date:
Subject: set_time_limit -VS- database queries