SPI_execp() failed in RI_FKey_cascade_del()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@xxxxxxxxxxxx



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux