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 по дате отправления: