Received: from smtpp.cnamts.fr (unknown [195.6.127.73]) by postgresql.org (Postfix) with SMTP id 3513B47583B for ; Thu, 21 Mar 2002 12:20:59 -0500 (EST) Received: from pivot.cnamts.fr ([127.0.0.1]) by pivot.NTCNAMTS (Netscape Messaging Server 3.5) with SMTP id 230 for ; Thu, 21 Mar 2002 18:17:58 +0100 Received: from PXXXX ([55.168.4.61]) by hermes1.cpam-cergypontoise.cnamts.fr (Netscape Messaging Server 3.5) with SMTP id 652 for ; Thu, 21 Mar 2002 18:29:53 +0100 Message-ID: <000c01c1d0fc$e36d1f40$3d04a837@PXXXX> From: "GRIMOIS Eric" To: Subject: Sequence not updated after a copy ? Date: Thu, 21 Mar 2002 18:21:50 +0100 Organization: CPAM du Val d'Oise MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200203/280 X-Sequence-Number: 7159 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