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
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 |