SQLSTATE code for duplicate constraint - Mailing list pgsql-general

From Dan Langille
Subject SQLSTATE code for duplicate constraint
Date
Msg-id 477D7F43.4000208@langille.org
Whole thread Raw
Responses Re: SQLSTATE code for duplicate constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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/

pgsql-general by date:

Previous
From: Geoffrey
Date:
Subject: Re: [OT] Slony (initial) Replication - Slow
Next
From: Tom Lane
Date:
Subject: Re: negative duration times in query logs