Re: pgrestore, notice, will create implicit.

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