Postgres Pro
Downloads
Home   >   mailing lists

Sequence not updated after a copy ? - Mailing list pgsql-sql

From GRIMOIS Eric
Subject Sequence not updated after a copy ?
Date
Msg-id 000c01c1d0fc$e36d1f40$3d04a837@PXXXX
Whole thread Raw
Responses Re: Sequence not updated after a copy ?  (Oliver Elphick <olly@lfix.co.uk>)
Re: Sequence not updated after a copy ?  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: Migrating a MySQL schema with an enum
Next
From: Oliver Elphick
Date:
Subject: Re: Sequence not updated after a copy ?