Sequence not updated after a copy ?

From: "GRIMOIS Eric" <eric(dot)grimois(at)cpam-cergypontoise(dot)cnamts(dot)fr>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Sequence not updated after a copy ?
Date: 2002-03-21 17:21:50
Message-ID: 000c01c1d0fc$e36d1f40$3d04a837@PXXXX
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All

Does 'COPY table FROM...' command update the last_value field of the
sequence(s) related to the table ?
Is a setval( ) function required after completion ? In this case, what's the
best command for doing that ?

Thanks

Eric GRIMOIS
Analyste programmeur
SEI - CPAM du Val d'Oise
01.34.22.24.56

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oliver Elphick 2002-03-21 19:01:24 Re: Sequence not updated after a copy ?
Previous Message Ross J. Reedstrom 2002-03-21 16:02:28 Re: Migrating a MySQL schema with an enum