Re: Bulkloading using COPY - ignore duplicates?

Поиск
Список
Период
Сортировка
От Lee Kindness
Тема Re: Bulkloading using COPY - ignore duplicates?
Дата
Msg-id 15389.59806.534505.201283@elsick.csl.co.uk
обсуждение исходный текст
Ответ на Re: Bulkloading using COPY - ignore duplicates?  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Bulkloading using COPY - ignore duplicates?  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut writes:> Jim Buttafuoco writes:> > I agree with Lee,  I also like Oracle's options for a discard file,
so>> you can look at what was rejected, fix your problem and reload if> > necessary just the rejects.> How do you know
whichone is the duplicate and which one is the good one?> More likely you will have to fix the entire thing.  Anything
elsewould> undermine the general data model except in specific use cases.
 

Consider SELECT DISTINCT - which is the 'duplicate' and which one is
the good one?

Lee.


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

Предыдущее
От: Lee Kindness
Дата:
Сообщение: Re: Bulkloading using COPY - ignore duplicates?
Следующее
От: bpalmer
Дата:
Сообщение: Re: 7.2 is slow?