Thread: Comments on Triggers and Rules are broken by pg_dump
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