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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
