Re: COMMENT ON INDEX silently fails

> Sure it does.

Okay, correct phrasing would be: It has unexpected effects.

> I suspect you were expecting the comment to be displayed in some
> place it
> isn't, but that's hard to discuss intelligently when you didn't say
> where
> you expected it to show up.

create table foo (f1 int primary key);
comment on index foo_pkey is 'test comment';
comment on constraint foo_pkey on foo is 'test comment 2';

# \di+
List of relations
Schema | Name | Type | Owner | Table | Size | Description
--------+----------+-------+----------+-------+------------+--------------
public | foo_pkey | index | postgres | foo | 8192 bytes | test comment
(1 row)

# SELECT * FROM pg_description WHERE description LIKE 'test com%';
objoid | classoid | objsubid | description
--------+----------+----------+----------------
123732 | 1259 | 0 | test comment
123733 | 2606 | 0 | test comment 2
(2 rows)

$ pgAdmin III

Before `comment on constraint` the textarea for comment is empty and no
statement for comment in SQL pane.

Afterwards it is using 'test comment 2'.

Best,
Michael