Postgres Pro
Downloads
Home   >   mailing lists

Deleting conflicting rows when creating a foreign key - Mailing list pgsql-general

From Igor Katson
Subject Deleting conflicting rows when creating a foreign key
Date
Msg-id 4991875F.4080508@gmail.com
Whole thread Raw
Responses Re: Deleting conflicting rows when creating a foreign key  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
I am doing an ALTER TABLE to create a foreign key, however with some
rows i get:

insert or update on table "name" violates foreign key constraint "name_fkey"

How can I just drop the conflicting rows while doing that?

pgsql-general by date:

Previous
From: SHARMILA JOTHIRAJAH
Date:
Subject: Re: ora2pg or dbi_link ?
Next
From: "Rob Richardson"
Date:
Subject: Slow database creation