The following bug has been logged on the website: Bug reference: 6317 Logged by: hua ming fei Email address: h...@alkheme.com PostgreSQL version: 9.0.1 Operating system: Centos 5.5 Description:
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, true);" 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 material 1004.10041 4.1 f 3013 38 2147483647 t 10042 disable 1004.10042 4.2 f -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
