Hello,
I'm porting an application's data from a proprietary format into PostgreSQL
7.2.1. I'm using ecpg and I basically follow this process:
create tables
create indexes
import data
add foreign key constraints
I have to add the foreign key constraint last as otherwise the import will fail
as the records being referenced won't necessarily exist in PostgreSQL yet. The
problem is that now I'd like to delete any records that violate the constraint.
Any suggestions on a quick way to do this?
--
Cliff Wells, Software Engineer
Logiplex Corporation (www.logiplex.net)
(503) 978-6726 x308 (800) 735-0555 x308
