Re: pgrestore, notice, will create implicit.

Поиск
Список
Период
Сортировка
От Marcel Franke
Тема Re: pgrestore, notice, will create implicit.
Дата
Msg-id F4C04E9EACCCA24B866A0E3716887C4B03E28ADD@EXCHANGER.nos-mc.local
обсуждение исходный текст
Ответ на pgrestore, notice, will create implicit.  ("Marcel Franke" <Marcel.Franke@omroep.nl>)
Ответы Re: pgrestore, notice, will create implicit.  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-novice
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
Дата:
Сообщение: Re: pgrestore, notice, will create implicit.
Следующее
От: Sean Davis
Дата:
Сообщение: Re: pgrestore, notice, will create implicit.