Re: INSERT or UPDATE - Mailing list pgsql-general

From James B. Byrne
Subject Re: INSERT or UPDATE
Date
Msg-id 38641.216.185.71.24.1239051949.squirrel@webmail.harte-lyne.ca
Whole thread Raw
In response to INSERT or UPDATE  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
Responses Re: INSERT or UPDATE
List pgsql-general
On Mon, April 6, 2009 17:00, Dann Corbit wrote:
.
>
> It is a difficult question.
>
> For instance, there are many possibilities when a collision occurs.
>
> I guess that for some collisions, sharing the name is OK.
>

I failed to explicitly state what the PK looked like.

  entity_id(entities.id) +
  identifier_type ('AKNA') +
  identifier_value(entities.common_name)

There will only be a PK collision when we attempt to add a duplicate
common name for the same entity, which means it already exists and
does not need to be added again.


--
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3



pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: tsearch2 dictionary for statute cites
Next
From: feridun türk
Date:
Subject: E-mail List -- Feridun Türk