Re: Duplicate key insert question

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Duplicate key insert question
Дата
Msg-id 20030702014303.GO27363@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: Duplicate key insert question  ("Dann Corbit" <DCorbit@connx.com>)
Список pgsql-general
On Tue, Jul 01, 2003 at 06:26:08PM -0700, Dann Corbit wrote:

> > But you should try to use a sequence if at all possible to avoid all
> > these problems.
>
> Does not really avoid the named issue.
>
> Suppose that you have a dictionary of working part numbers (e.g. Boeing
> might have 3 million distinct parts in their database).
> They would like to create a domain for these parts.  So, naturally, they
> take their list and do
> %cat list.dat|sort|uniq>list.sor
> And then bulk load list.sor.

Oh, sure.  The sequence thing won't apply everywhere.  But maybe it can
be applied in his scenario, which I don't know.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Voy a acabar con todos los humanos / con los humanos yo acabaré
voy a acabar con todos / con todos los humanos acabaré (Bender)

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Duplicate key insert question
Следующее
От: Jean-Christian Imbeault
Дата:
Сообщение: Re: Duplicate key insert question