Re: pg_dump of table including check rule fails to restore - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: pg_dump of table including check rule fails to restore
Date
Msg-id 200312162225.43099.peter_e@gmx.net
Whole thread Raw
In response to Re: pg_dump of table including check rule fails to restore  ("Lewis Foti" <lewis.foti@mentation.com>)
List pgsql-bugs
Lewis Foti wrote:
> Further to my original message I realise that the problem was due to
> the text of the rule still referring to columns, src_section_id and
> dst_section_id by their original names, parent_section_id and
> child_section_id respectively. So the nature of the bug changes to
> that pg_dump does not correctly export CHECK rules where the name of
> the column(s) referred to has changed. Now IMHO that is somewhat
> subtle.

This appears to be fixed in 7.4.  Upgrading might be your best option
unless you want to backport the pg_dump fix to 7.3.

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pg_dump of table including check rule fails to restore
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1011: Explain analyze "query" cause segv