index naming conventions

Joseph Shraibman <jks@selectacast.net> writes:

playpen=# create table jm(
playpen(# jid int NOT NULL,
playpen(# mid int ,
playpen(# UNIQUE(jid, mid)
playpen(# );
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'jm_jid_key' for table 'jm'
CREATE

Why isn't the index created called 'jm_jid_mid_key' ?

Laziness, mainly. There's a subroutine in the parser that's responsible
for forming these names and doing truncation if they are too long. It
only handles three name components (table, field, and "_key" suffix) at
the moment. Feel free to submit a patch that makes it smarter...

regards, tom lane