Peter Eisentraut wrote: > 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.
Why wouldn't it default to a name more like: CREATE INDEX "foo(a)" on foo(a); which would extend pretty nicely to things like: CREATE INDEX "foo USING GIN(hstore)" ON foo USING GIN(hstore);' Seems to be both more readable and less chance for arbitrary collisions if I have column names with underscores. Otherwise what would the rule distinguishing "create index on foo(a_b)" from "create index on foo(a,b)", etc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers