[BUGS] pg_dump of table including check rule fails to restore

[Lewis Foti]

Hi

 

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?

 

regards

 

Lewis

 

--
-- TOC entry 6 (OID 154551)
-- Name: navigation; Type: TABLE; Schema: public; Owner: wallet
--

 

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;

Lewis Foti

e: [EMAIL PROTECTED]
m: +44 (0)7771 535943
w: www.mentation.com