Does pg_dump stable on v7.0
От | Jie Liang |
---|---|
Тема | Does pg_dump stable on v7.0 |
Дата | |
Msg-id | Pine.BSF.4.10.10104061026370.17226-100000@tidal.ipinc.com обсуждение исходный текст |
Ответ на | Re: 7.1 out soon? (The Hermit Hacker <scrappy@hub.org>) |
Список | pgsql-admin |
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@ipinc.com www.stbernard.com www.ipinc.com
В списке pgsql-admin по дате отправления: