Re: Error Trapping -duplicate keys

Steven:

Try using a
   select count(*)
   from <table>
   where <field of the primary key>=<key to be
inserted>.

 to check the count of the data.
  if count is zero insert else update.

--- "Steven D. Smith" <sds07@health.state.ny.us>
wrote:
> Help:
>
> I'm using Perl to insert data from a log file, what
> I am doing is this
> (Pseudocode):
>
> If NOT (INSERT INTO myTABLE)
> THEN UPDATE myTABLE
> endIf
>
> Now the code I have works except I get a console
> message:
>
>       DBD::Pg::st execute failed: ERROR:  Cannot
> insert a duplicate key
> into unique index visitor_pkey at ./inslog.pl line
> 147, <> chunk 4.
>
> So, my question is how to I trap this error, keep it
> from being display as
> it is not really an error if the insert fails?


ludwig.



__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com