Re: error handling - Mailing list pgsql-novice

From Verena Ruff
Subject Re: error handling
Date
Msg-id 4462FC2B.2010601@triosolutions.at
Whole thread Raw
In response to Re: error handling  (Sean Davis <sdavis2@mail.nih.gov>)
List 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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuuming static tables.
Next
From:
Date:
Subject: Dev DB Structure Updates