Deleting conflicting rows when creating a foreign key

[Igor Katson <descentspb@xxxxxxxxx>]

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?

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general