Delete / F/K error

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Delete / F/K error
Date: 2005-12-30 20:09:12
Message-ID: 20051230200912.86766.qmail@web52911.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I tried to delete a row from 'sites' and get this
rather complex error:

SQL error:

ERROR: insert or update on table "types" violates
foreign key constraint "$1"
DETAIL: Key (page_template_id)=(8) is not present in
table "templates".
CONTEXT: SQL statement "UPDATE ONLY "public"."types"
SET "item_template_id" = NULL WHERE "item_template_id"
= $1"
SQL statement "DELETE FROM ONLY "public"."templates"
WHERE "site_id" = $1"

In statement:
DELETE FROM "sites" WHERE "id"='1'

I'm not sure what's wrong, or how to fix it. Any
ideas?

thanks
csn


__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2005-12-30 20:55:16 Re: Forum Software
Previous Message MargaretGillon 2005-12-30 19:54:56 Visual FoxPro 9 ODBC errors