creating index names automatically?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: creating index names automatically?
Date: 2009-12-19 21:06:41
Message-ID: 1261256801.3347.3.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Could we create an option to create index names automatically, so you'd
only have to write

CREATE INDEX ON foo (a);

which would pick a name like foo_a_idx. We already do this in a number
of places such as constraint names and sequences without much trouble.
In most cases you don't really need to give an index a smart name since
the purpose is obvious.

Comments?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brendan Jurd 2009-12-19 21:08:25 Re: creating index names automatically?
Previous Message Tom Lane 2009-12-19 20:01:50 Re: LATERAL