From: | "Marcin Gil" <marcin(dot)gil(at)audax(dot)com(dot)pl> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | pg 7.2.3 -> pg 7.3.3: pg_atoi error |
Date: | 2003-07-31 07:08:05 |
Message-ID: | 003b01c35732$7dbb3cf0$2402a8c0@mg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello!
I tried to upgrade postgresql from v. 7.2.3 to 7.3.3.
I did pg_dump of the database and tried to read it in
using new version.
Below is a cut from my out file:
-- TOC Entry ID 101 (OID 16855)
--
-- Name: co_sys_meta_vtable_sqid Type: SEQUENCE Owner: root
--
CREATE SEQUENCE "co_sys_meta_vtable_sqid" start 1 increment 1 maxvalue
9223372036854775807 minvalue 1 cache 1;
--
-- TOC Entry ID 103 (OID 16855)
--
-- Name: co_sys_meta_vtable_sqid Type: ACL Owner:
--
REVOKE ALL on "co_sys_meta_vtable_sqid" from PUBLIC;
GRANT ALL on "co_sys_meta_vtable_sqid" to "root";
GRANT ALL on "co_sys_meta_vtable_sqid" to "nobody";
--
-- TOC Entry ID 411 (OID 16857)
--
-- Name: co_sys_meta_vtable Type: TABLE Owner: root
--
CREATE TABLE "co_sys_meta_vtable" (
"id" integer DEFAULT nextval('co_sys_meta_vtable_sqid'::text),
"version" integer DEFAULT 0,
"deleted" integer DEFAULT 0,
"inherits_acl" integer DEFAULT 1,
"area" text DEFAULT 'sys',
"class_name" text DEFAULT '',
"method_name" text DEFAULT '',
"target_area" text DEFAULT 'sys',
"target_class_name" text DEFAULT '',
"id_permission" integer DEFAULT '',
"id_onbefore_script" integer DEFAULT 0,
"id_onbefore_method" integer DEFAULT 0,
"id_script" integer DEFAULT 0,
"id_onafter_script" integer DEFAULT 0,
"id_onafter_method" integer DEFAULT 0,
"profiled" integer DEFAULT 0,
"sec_type" integer DEFAULT 0,
"force_sec_type" integer DEFAULT 0
);
--
-- TOC Entry ID 412 (OID 16857)
--
-- Name: co_sys_meta_vtable Type: ACL Owner:
--
REVOKE ALL on "co_sys_meta_vtable" from PUBLIC;
GRANT ALL on "co_sys_meta_vtable" to "root";
GRANT ALL on "co_sys_meta_vtable" to "nobody";
I get an pg_atoi error while reading in co_sys_meta_vtable,
I suppose at this
"id" integer DEFAULT nextval('co_sys_meta_vtable_sqid'::text),
particular line.
Is there a way to successfully transport such a db into new version?
The dump has almost 3G, so hand-editing is not a case..
TIA,
--
Marcin Gil
marcin.gil @ audax.com.pl, tel. 694972082
OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
tel/fax (44) 7247530, 7244401
From | Date | Subject | |
---|---|---|---|
Next Message | Godshall Michael | 2003-07-31 14:25:58 | Re: pg_atoi error? |
Previous Message | Cath Lawrence | 2003-07-31 01:10:23 | Re: designing tables for blobs - what are the guidelines? |