BUG #6317: sequence error for pg_dump - Mailing list 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