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

Lewis Foti wrote:
> I have a schema which includes one table with a CHECK constraint.
> After the schema is dumped (with pg_dump) as ascii text attempts to
> recreate it using the psql -f <filename> command cause this one
> table, called navigaion, to fail to create. This is using postgresql
> 7.3.3 on Redhat 9.0.  The fragment of the dump is below. Is there a
> cure for this problem?

> CREATE TABLE navigation (
>     src_section_id integer NOT NULL,
>     dst_section_id integer NOT NULL,
>     rank smallint NOT NULL,
>     CHECK ((parent_section_id <> child_section_id))
> ) WITHOUT OIDS;

Can you remember how you constructed this table?  Did you drop or alter
some columns?  Do you have your original table creation script around
or something like that?

Obviously, this table is invalid, but we need to find out how you
arrived there.