COMMENT ON COLUMN returns error for view

[kyleconroy]

Related to #193, #191

This breaks if one of your comments is on a view.

CREATE TABLE users (name TEXT);

CREATE VIEW harrys AS
  SELECT name
  FROM users
  WHERE name ILIKE '%harry%';

COMMENT ON harrys.name IS 'Harry's name';

relation "harrys" does not exist

Originally posted by @maxhawkins in #191 (comment)

[kyleconroy]

I don't think this is a bug. COMMENT ON requires the object type before the comment.

-- invalid
COMMENT ON harrys.name IS 'Harry's name';

-- valid
COMMENT ON VIEW harrys.name IS 'Harry's name';

Currently, unimplemented object types are ignored, so COMMENT ON VIEW is ignored.

[maxhawkins]

Oops I forgot the COLUMN. I can reproduce this failure:

CREATE TABLE users (name TEXT);

CREATE VIEW harrys AS
  SELECT name
  FROM users
  WHERE name ILIKE '%harry%';

COMMENT ON COLUMN harrys.name IS 'Harry''s name';

relation "harrys" does not exist

[kyleconroy]

As of v1.9.0, I can no longer reproduce this issue. Take a look at here.