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.