Received: from hapcibeno.freestart.hu (hapcibeno.freestart.hu [213.197.64.8]) by postgresql.org (Postfix) with ESMTP id 73ADC475F9B for ; Tue, 9 Apr 2002 05:45:42 -0400 (EDT) Received: from line-74-91.dial.freestart.hu ([213.197.74.91] helo=jaguar) by freestart.hu with smtp (Freestart relay 2 (FS-Lin)) id 16usHp-0000rJ-00 for ; Tue, 09 Apr 2002 11:51:37 +0200 Message-ID: <007801c1dfab$9070d580$01fdfea9@jaguar> Reply-To: "Papp, Gyozo" From: "Papp, Gyozo" To: "postgres+php" Subject: SPI_execp() failed in RI_FKey_cascade_del() Date: Tue, 9 Apr 2002 11:47:29 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Scanner: exiscan by Freestart X-Archive-Number: 200204/23 X-Sequence-Number: 1047 Hi, does anyone know what this error message refers to?=20 PostgreSQL query failed: ERROR: SPI_execp() failed in RI_FKey_cascade_del() The $query was "DELETE FROM request WHERE request_id=3D33 AND label=3D'DEMO= 2';" 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=20 CONSTRAINT f_request_id=20 REFERENCES request ON DELETE CASCADE=20 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