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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend