On Fri, Oct 08, 2004 at 04:21:01PM -0500, Josh Close wrote: > On Fri, 8 Oct 2004 23:15:24 +0200, Martijn van Oosterhout > <[EMAIL PROTECTED]> wrote: > > You havn't posted the exact error message. You'll have to if you want > > people to properly explain what's going on... > > update or delete on "tblheadings" violates foreign key constraint "$1" > on "tblheadings" DETAIL: Key (iid)=(22) is still referenced from table > "tblheadings"
This looks like tblheadings has a foreign key reference to itself. Is this the *exact* error message, cut-and-pasted? What do your table definitions look like? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly