Project

General

Profile

« Previous | Next » 

Revision 13483

bugfix: schemas/util.sql: mk_set_comment(): need to use VIEW instead of TABLE for views

View differences:

util.sql
2546 2546
CREATE FUNCTION mk_set_comment(table_ regclass, comment text) RETURNS text
2547 2547
    LANGUAGE sql STABLE
2548 2548
    AS $_$
2549
SELECT COALESCE($$COMMENT ON TABLE $$||$1||$$ IS $$
2549
SELECT COALESCE($$COMMENT ON $$||util.relation_type($1)||$$ $$||$1||$$ IS $$
2550 2550
||quote_literal($2)/*pass NULL through*/||$$;$$, ''/*no comment*/)
2551 2551
$_$;
2552 2552

  

Also available in: Unified diff