SQLSTATE code for duplicate constraint

From: Dan Langille <dan(at)langille(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: SQLSTATE code for duplicate constraint
Date: 2008-01-04 00:35:15
Message-ID: 477D7F43.4000208@langille.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi folks,

With reference to:

http://www.postgresql.org/docs/8.2/interactive/errcodes-appendix.html

What error code would be raised for a duplicate index name?

I didn't see anything appropriate. Possibly: 42710 DUPLICATE OBJECT

thanks

--
Dan Langille - http://www.langille.org/
BSDCan - The Technical BSD Conference: http://www.bsdcan.org/
PGCon - The PostgreSQL Conference: http://www.pgcon.org/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-01-04 00:35:25 Re: negative duration times in query logs
Previous Message Geoffrey 2008-01-04 00:17:00 Re: [OT] Slony (initial) Replication - Slow