| From: | hmf(at)alkheme(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #6317: sequence error for pg_dump |
| Date: | 2011-12-02 09:48:01 |
| Message-ID: | E1RWPir-0003bE-8Z@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 6317
Logged by: hua ming fei
Email address: hmf(at)alkheme(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Goerner | 2011-12-02 10:56:36 | Re: BUG #6308: Problem w. encoding in client |
| Previous Message | Jon Erdman | 2011-12-02 06:48:08 | Re: BUG #6316: function search_path causes set_config() is_local = true to have no effect |