Removing records that violate foreign key

Поиск
Список
Период
Сортировка
От Cliff Wells
Тема Removing records that violate foreign key
Дата
Msg-id 20020618101232.04987af7.logiplexsoftware@earthlink.net
обсуждение исходный текст
Ответы Re: Removing records that violate foreign key  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: set permanent date style
Следующее
От: Digital Wokan
Дата:
Сообщение: Re: Uppercase field names not found