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
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 |
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 |