Re: pgrestore, notice, will create implicit.

Поиск
Список
Период
Сортировка
Искать
От
Marcel Franke
Тема
Re: pgrestore, notice, will create implicit.
Дата
Msg-id
F4C04E9EACCCA24B866A0E3716887C4B03E28ADD@EXCHANGER.nos-mc.local
Список
Дерево обсуждения
Re: pgrestore, notice, will create implicit. "Marcel Franke" <Marcel.Franke@omroep.nl>

Sean:

>Your schema definition probably contains a "serial primary key".  
>The "serial" part uses a sequence to do the auto-incremented values, so
postgres needs to create that sequence
>A primary key needs to have an associated index, so by asking for a
primary key, postgres needs to create the index 

Thank you very much.

So, if I understand correctly,
the serial primary keys and its index are recreated.

Which means that the value of the primary keys in the restored database
may not be the same
as the value of the primary keys in the original database ?

Kind regards,
Marcel.
В списке pgsql-novice по дате отправления
От: Sean Davis
Дата:
От: Sean Davis
Дата:
FAQ