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