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  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Thomas Goerner"
Дата:
Сообщение: Re: BUG #6308: Problem w. encoding in client
Следующее
От: Josh Kupershmidt
Дата:
Сообщение: Re: 9.1.1 hot standby startup gets sigbus