SPI_execp() failed in RI_FKey_cascade_del()

Поиск
Список
Период
Сортировка
От Papp, Gyozo
Тема SPI_execp() failed in RI_FKey_cascade_del()
Дата
Msg-id 007801c1dfab$9070d580$01fdfea9@jaguar
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: John Starkey
Дата:
Сообщение: Greek/PHP/PostgreSQL
Следующее
От: "Areski Belaid"
Дата:
Сообщение: set_time_limit -VS- database queries