Re: pgrestore, notice, will create implicit. - Mailing list pgsql-novice

From Marcel Franke
Subject Re: pgrestore, notice, will create implicit.
Date
Msg-id F4C04E9EACCCA24B866A0E3716887C4B03E28ADD@EXCHANGER.nos-mc.local
Whole thread Raw
In response to pgrestore, notice, will create implicit.  ("Marcel Franke" <Marcel.Franke@omroep.nl>)
Responses Re: pgrestore, notice, will create implicit.
List 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 by date:

Previous
From: Sean Davis
Date:
Subject: Re: pgrestore, notice, will create implicit.
Next
From: Sean Davis
Date:
Subject: Re: pgrestore, notice, will create implicit.