Re: foreign key constraints, cannot delete [SOLVED]

From: Josh Close <narshe(at)gmail(dot)com>
To: POSTGRES <pgsql-general(at)postgresql(dot)org>
Subject: Re: foreign key constraints, cannot delete [SOLVED]
Date: 2004-10-09 03:51:27
Message-ID: 4a0cafe204100820513a988325@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 8 Oct 2004 18:14:50 -0600, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
> 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

There isn't a foreign key reference to itself. I figured out the
problem. I had to print out all the queries and manually figure out
the data that was being deleted. Turns out there was one value the
wasn't being removed. So the begin and commit do work like they
should.

Thanks.

-Josh

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2004-10-09 06:10:36 Re: Fix setArray() when using the v3 protocol (was Re: Postgres
Previous Message Bruce Momjian 2004-10-09 00:32:56 Re: Rollback on Error