Revision 13483
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/schemas/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
bugfix: schemas/util.sql: mk_set_comment(): need to use VIEW instead of TABLE for views