From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | Marcel Franke <Marcel(dot)Franke(at)omroep(dot)nl>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: pgrestore, notice, will create implicit. |
Date: | 2006-06-01 12:15:40 |
Message-ID: | C0A452AC.C48D%sdavis2@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 6/1/06 7:57 AM, "Marcel Franke" <Marcel(dot)Franke(at)omroep(dot)nl> wrote:
> Hello,
>
> I am trying to restore a database with pg_restore,
> (psql 7.4.6 on Linux 2.6.9-5.ELsmp (RedHat 4))
> but I do not understand what the specific -notice- messages mean
> that the pg_restore produces:
> Can someone please tell me what
> "will create implicit sequence"
> and
> "will create implicit index"
> means ?
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 (which is "implied" by the "serial"
definition). A primary key needs to have an associated index, so by asking
for a primary key, postgres needs to create the index (a primary key
"implies" the need for an index).
Hope that helps.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Marcel Franke | 2006-06-01 12:38:48 | Re: pgrestore, notice, will create implicit. |
Previous Message | Marcel Franke | 2006-06-01 11:57:51 | pgrestore, notice, will create implicit. |