Comments broken by pg_dump (ianh@tpchd.org) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Comments on Triggers and Rules are broken by pg_dump
Long Description
Comments are created before the corresponding trigger or rule on my database when it is dumped with pg_dump and
restored.
Sample Code
--
*** Found at line 2796 of dump ***
-- TOC Entry ID 337 (OID 969836)
--
-- Name: TRIGGER "trig_itemyear_atrig" ON "itemyear" Type: COMMENT Owner:
--
COMMENT ON TRIGGER "trig_itemyear_atrig" ON "itemyear" IS 'Calls tsp_itemyear_atrig on update or insert of itemyear
records.';
*** Found at line 39333 of dump ***
--
-- TOC Entry ID 336 (OID 969836)
--
-- Name: trig_itemyear_atrig Type: TRIGGER Owner: iharding
--
CREATE TRIGGER "trig_itemyear_atrig" AFTER DELETE OR UPDATE ON "itemyear" FOR .....
No file was uploaded with this report