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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers