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