Re: creating index names automatically?
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org
Date: 2009-12-19T22:04:55Z
Lists: pgsql-hackers
I wrote: > In the cases where that's sensible, you can use constraint syntax, no? > I really doubt that it's that easy to pick a sensible name for an index > on an expression, for example. Although, having said that, I realize we just opened that can of worms with the exclusion-constraint patch: regression=# create table foo (f1 text, exclude (lower(f1) with =)); NOTICE: CREATE TABLE / EXCLUDE will create implicit index "foo_exclusion" for table "foo" CREATE TABLE The above behavior seems to need improvement already. regards, tom lane