Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D9B282E0085 for ; Tue, 26 Feb 2008 11:08:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 48234-04 for ; Tue, 26 Feb 2008 11:07:57 -0400 (AST) X-Greylist: delayed 00:12:20.921857 by SQLgrey-1.7.5 Received: from smtpout24.attiva.biz (smtpout24.attiva.biz [85.37.16.25]) by postgresql.org (Postfix) with ESMTP id 207E52E0049 for ; Tue, 26 Feb 2008 11:08:04 -0400 (AST) Received: from FBCMFE02B16.fbc.local ([192.168.31.239]) by smtpout24.attiva.biz with Microsoft SMTPSVC(6.0.3790.1830); Tue, 26 Feb 2008 15:55:42 +0100 Received: from dream ([88.34.161.130]) by FBCMFE02B16.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Tue, 26 Feb 2008 15:55:41 +0100 Message-ID: <014401c87887$a8fed450$3102a8c0@dream> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: Subject: duplicate key violates unique constraint Date: Tue, 26 Feb 2008 15:55:42 +0100 Organization: Studio FORM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0141_01C87890.0A44BD80" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-OriginalArrivalTime: 26 Feb 2008 14:55:41.0206 (UTC) FILETIME=[A7DA0360:01C87887] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/200 X-Sequence-Number: 30291 This is a multi-part message in MIME format. ------=_NextPart_000_0141_01C87890.0A44BD80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello=20 During an "INSERT INTO" I get an "Error - duplicate key violates unique = constraint...." Is there any way, that i can test the error. Something like this?? IF error =3D "duplicate key violates unique constraint" then do something else=20 insert into end if Thanks Shavonne ------=_NextPart_000_0141_01C87890.0A44BD80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello
 
During an "INSERT INTO" I get an = "Error -=20 duplicate key violates unique=20 constraint...."
 
Is there any way, that i can = test the=20 error. Something like this??
 
IF error =3D "duplicate key violates = unique=20 constraint" then
    do = something
else
    insert = into
end if
 
 
Thanks
 
Shavonne
------=_NextPart_000_0141_01C87890.0A44BD80--