Does pg_dump stable on v7.0

From: Jie Liang <jliang(at)ipinc(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Does pg_dump stable on v7.0
Date: 2001-04-06 17:37:18
Message-ID: Pine.BSF.4.10.10104061026370.17226-100000@tidal.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql


When I dump out my whole db with pg_dump -x dbname > dbname.out
then when I reload them, one of creation always failed
msg is relation 'urlinfo' is not exist,
so I dump out scheme first -- pg_dump -x -a dbname > dbname.out.s
reload them , samething happend, so I cut & paste the definition of
this table, it's OK. then load data is OK.

but how come??

foollowing is this table:
CREATE TABLE "urlinfo" (
"url" text NOT NULL,
"id" int4 NOT NULL,
"ratedby" character varying(32),
"ratedon" timestamp DEFAULT "timestamp"('now'::text),
"comments" text,
"list" int2,
"pidwsr" int4,
CONSTRAINT "host_ck" CHECK ((((((urlpart('host'::text,
(url)::"varchar") <> '*.com'::text) AND (urlpart('host'::text,
(url)::"varchar") <> '*.net'::text)) AND (urlpart('host'::text,
(url)::"varchar") <> '*.gov'::text)) AND (urlpart('host'::text,
(url)::"varchar") <> '*.*'::text)) AND (urlpart('host'::text,
(url)::"varchar") <> '*'::text))),
PRIMARY KEY ("id")
);

Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2001-04-07 04:00:16 pgmonitor completed
Previous Message Peter Eisentraut 2001-04-06 14:44:55 Re: base/1 instead of base/template1 initdb result

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-04-06 23:32:30 "row_count" reserved?
Previous Message Richard 2001-04-06 16:45:50 pg_dump and oid