Re: pgrestore, notice, will create implicit.

From: "Marcel Franke" <Marcel(dot)Franke(at)omroep(dot)nl>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: pgrestore, notice, will create implicit.
Date: 2006-06-01 12:38:48
Message-ID: F4C04E9EACCCA24B866A0E3716887C4B03E28ADD@EXCHANGER.nos-mc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2006-06-01 12:45:35 Re: pgrestore, notice, will create implicit.
Previous Message Sean Davis 2006-06-01 12:15:40 Re: pgrestore, notice, will create implicit.