Comments on Triggers and Rules are broken by pg_dump

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Comments on Triggers and Rules are broken by pg_dump
Date: 2001-06-29 20:49:23
Message-ID: 200106292049.f5TKnNp81230@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Comments broken by pg_dump (ianh(at)tpchd(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-06-30 03:21:22 insert into table (column) values ('string'); fail
Previous Message Bruce Momjian 2001-06-29 15:34:02 Re: Bug with POSTGRESQL JDBC Driver 7.1 -1.2