Re: error handling

From: Verena Ruff <lists(at)triosolutions(dot)at>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: error handling
Date: 2006-05-11 08:56:11
Message-ID: 4462FC2B.2010601@triosolutions.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

Sean Davis schrieb:
> No problem. I was thinking that you had a bunch of data that you
> wanted to load ONCE, clean up, and then you would NOT be inserting
> duplicated values. If you are going to be inserting duplicates
> potentially with every insert, I think that a trigger is the only way
> to go on the DB side of things. Of course, you could do things on the
> client side, as well (do a lookup, find nothing--do insert, find
> something--do nothing or do update).

Thanks for your opinion. Then I'll go with a trigger.

Regards,
Verena

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Mark Campbell 2006-05-11 11:21:48 Compiling on 8.1.3 on Openserver 5.05
Previous Message atsorgassa 2006-05-11 08:45:25 insert performance