pg 7.2.3 -> pg 7.3.3: pg_atoi error - Mailing list pgsql-novice

From Marcin Gil
Subject pg 7.2.3 -> pg 7.3.3: pg_atoi error
Date
Msg-id 003b01c35732$7dbb3cf0$2402a8c0@mg
Whole thread Raw
List 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


pgsql-novice by date:

Previous
From: Cath Lawrence
Date:
Subject: Re: designing tables for blobs - what are the guidelines?
Next
From: Godshall Michael
Date:
Subject: Re: pg_atoi error?