Dan Langille <[EMAIL PROTECTED]> writes:
> What error code would be raised for a duplicate index name?
regression=# \set VERBOSITY verbose
regression=# create table t1 (f1 int);
CREATE TABLE
regression=# create index t1i on t1(f1);
CREATE INDEX
regression=# create index t1i on t1(f1);
ERROR: 42P0
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 Te
