BUG #6317: sequence error for pg_dump
| От | hmf@alkheme.com |
|---|---|
| Тема | BUG #6317: sequence error for pg_dump |
| Дата | |
| Msg-id | E1RWPir-0003bE-8Z@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #6317: sequence error for pg_dump
|
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 6317
Logged by: hua ming fei=20
Email address: hmf@alkheme.com
PostgreSQL version: 9.0.1
Operating system: Centos 5.5
Description:=20=20=20=20=20=20=20=20
use pg_dump when didn't close the application , weird things occured . =
the
current value of one sequence is more slower than the max number of one
primary key base on the sequence . So, I looked into the dump file , found
command"
SELECT pg_catalog.setval('attrnamemaster_attrnameid_seq', 3009, tru=
e);" to
set sequence values number , but the import data, there are many lines with
number larger than the sequence value :
3012 38 2147483647 t 10041 material material=20=
=20=20=20
material 1004.10041 4.1 f
3013 38 2147483647 t 10042 disable=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20
1004.10042 4.2 f=20
В списке pgsql-bugs по дате отправления: