pg_dump of table including check rule fails to restore

From: "Lewis Foti" <lewis(dot)foti(at)mentation(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: pg_dump of table including check rule fails to restore
Date: 2003-12-16 18:26:23
Message-ID: MJEPJJCNLEBMDJFMDDABEEHNCDAA.lewis.foti@mentation.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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: lewis(dot)foti(at)mentation(dot)com
m: +44 (0)7771 535943
w: www.mentation.com

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Lewis Foti 2003-12-16 18:48:06 Re: pg_dump of table including check rule fails to restore
Previous Message PostgreSQL Bugs List 2003-12-16 17:04:44 BUG #1010: format_type errors oin formatting type interval.