It seems to have a problem when making backup and restore with type
bigserial. I perceived when was restoring a database and the sequence
created for field bigserial was not correctly restored.
For example, i've created the follow structure:
CREATE TABLE cager.princ
(
cd_princ bigserial NOT NULL,
nm_princ character varying(50),
CONSTRAINT "pk-princ-cd_princ" PRIMARY KEY (cd_princ)
)
WITHOUT OIDS;
Making backup with:
C:\Arquivos de programas\pgAdmin III\1.6\pg_dump.exe -i -h 192.168.7.1 -p
5432 -U postgres -F c -b -v -f "C:\Temp\testepad.backup" testepad
Making restore with:
C:\Arquivos de programas\pgAdmin III\1.6\pg_restore.exe -i -h 192.168.7.1 -p
5432 -U postgres -d test1 -v "C:\Temp\testepad.backup"
The same table now is:
CREATE TABLE cager.princ
(
cd_princ bigint NOT NULL DEFAULT nextval('princ_cd_princ_seq'::regclass),
nm_princ character varying(50),
CONSTRAINT "pk-princ-cd_princ" PRIMARY KEY (cd_princ)
)
WITHOUT OIDS;
Take a look at the field cd_princ. Next value should be
'cager.princ_cd_princ_seq'.
I've tested it with pg_admin version 1.6.2 and 1.4.3.
If need more information, please, contact me.
Follow in annex messages on restoring.
Att.
Márcio A. Sepp
ZYON TECNOLOGIA LTDA
55 (49) 3444-4591
55 (49) 8405-9215
C:\Arquivos de programas\pgAdmin III\1.6\pg_restore.exe -i -h 192.168.7.1 -p
5432 -U postgres -d test1 -v "C:\Temp\testepad.backup"
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] Error while INITIALIZING:
pg_restore: [archiver (db)] could not execute query: ERROR: parameter
"standard_conforming_strings" cannot be changed
Command was: SET standard_conforming_strings = off;
pg_restore: creating SCHEMA cager
pg_restore: creating SCHEMA public
pg_restore: creating COMMENT SCHEMA public
pg_restore: creating TABLE princ
pg_restore: creating SEQUENCE princ_cd_princ_seq
pg_restore: creating SEQUENCE OWNED BY princ_cd_princ_seq
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1514; 0 0 SEQUENCE OWNED BY
princ_cd_princ_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or
near "OWNED"
LINE 1: ALTER SEQUENCE princ_cd_princ_seq OWNED BY princ.cd_princ;
^
Command was: ALTER SEQUENCE princ_cd_princ_seq OWNED BY princ.cd_princ;
pg_restore: executing SEQUENCE SET princ_cd_princ_seq
pg_restore: creating DEFAULT cd_princ
pg_restore: restoring data for table "princ"
pg_restore: creating CONSTRAINT pk-princ-cd_princ
pg_restore: setting owner and privileges for SCHEMA cager
pg_restore: setting owner and privileges for SCHEMA public
pg_restore: setting owner and privileges for COMMENT SCHEMA public
pg_restore: setting owner and privileges for ACL public
pg_restore: setting owner and privileges for TABLE princ
pg_restore: setting owner and privileges for SEQUENCE princ_cd_princ_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY
princ_cd_princ_seq
pg_restore: setting owner and privileges for DEFAULT cd_princ
pg_restore: setting owner and privileges for CONSTRAINT pk-princ-cd_princ
WARNING: errors ignored on restore: 2
Process returned exit code 1.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
