Home > mailing lists

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

From	GRIMOIS Eric
Subject	Sequence not updated after a copy ?
Date	March 21, 2002 15:21:10
Msg-id	000c01c1d0fc$e36d1f40$3d04a837@PXXXX Whole thread Raw
Responses	Re: Sequence not updated after a copy ? Re: Sequence not updated after a copy ?
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:

From: "Ross J. Reedstrom"
Date: 21 March 2002, 14:02:42
Subject: Re: Migrating a MySQL schema with an enum

From: Oliver Elphick
Date: 21 March 2002, 17:01:46
Subject: Re: Sequence not updated after a copy ?

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

Previous

Next