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