Horton
Menu

Re: creating index names automatically?

Michael Glaesemann <grzm@seespotcode.net>

View thread
From: Michael Glaesemann <grzm@seespotcode.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org
Date: 2009-12-20T19:22:51Z
Lists: pgsql-hackers 
On Dec 20, 2009, at 13:58 , Tom Lane wrote:

> * Append "_index" not "_key" if it's not a constraint-related index.

"_idx" instead of "_index" keeps things a bit shorter (and a couple of  
keystrokes further from NAMEDATALEN). There's precedent for  
abbreviations with automatic naming in Postgres, e.g., "_fkey".

Michael Glaesemann
grzm seespotcode net