Re: Duplicate key insert question - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Duplicate key insert question
Date
Msg-id 20030702014303.GO27363@dcc.uchile.cl
Whole thread Raw
In response to Re: Duplicate key insert question  ("Dann Corbit" <DCorbit@connx.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Duplicate key insert question
Next
From: Jean-Christian Imbeault
Date:
Subject: Re: Duplicate key insert question