BUG #2552: wrong sql dump?
От | Boris |
---|---|
Тема | BUG #2552: wrong sql dump? |
Дата | |
Msg-id | 200607261115.k6QBFn45087753@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #2552: wrong sql dump?
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2552 Logged by: Boris Email address: b.koshevoy@vk-brok.kiev.ua PostgreSQL version: 8.1.4 Operating system: win 2000 Description: wrong sql dump? Details: Hi! data base lives from pg7.2 before upgrade to 8.1.2 I used pgdump from 7.2 then I go to pg 8.1.4 and pgAdmin III 1.4.3 (Jul 19 2006) The sequence for primry key (PK) of some (not all) was missed and PK become wrong - allways 0. I export all base as sql script (1). When I import this script I see no sequences for sope PK. I see no commands to create sequences in this (1)sql script. ForEx: table "auth"."access_policy_list" has a PK but no sequence is created. See sql dump here http://www.bdr.kiev.ua/tmpboris/bdr_v0_plain.zip ICQ 176869864 for any more info, please. :)
В списке pgsql-bugs по дате отправления: