pg_dump of table including check rule fails to restore
От | Lewis Foti |
---|---|
Тема | pg_dump of table including check rule fails to restore |
Дата | |
Msg-id | MJEPJJCNLEBMDJFMDDABEEHNCDAA.lewis.foti@mentation.com обсуждение исходный текст |
Ответы |
Re: pg_dump of table including check rule fails to restore
Re: pg_dump of table including check rule fails to restore |
Список | 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.foti@mentation.com m: +44 (0)7771 535943 w: www.mentation.com
В списке pgsql-bugs по дате отправления: