Received: from falla.videotron.net (falla.videotron.net [205.151.222.106]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA58530 for ; Mon, 22 May 2000 15:22:40 -0400 (EDT) (envelope-from pcoulombe@mediacces.com) Received: from mediacces.com ([24.201.179.114]) by falla.videotron.net (Sun Internet Mail Server sims.3.5.1999.12.14.10.29.p8) with ESMTP id <0FUZ00M4F5VJBZ@falla.videotron.net> for pgsql-sql@postgresql.org; Mon, 22 May 2000 14:54:55 -0400 (EDT) Date: Mon, 22 May 2000 02:53:42 -0400 From: Patrick Coulombe Subject: re: duplicate key To: pgsql-sql@postgresql.org Message-id: <3928D976.C30940B5@mediacces.com> MIME-version: 1.0 X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en X-Archive-Number: 200005/101 hi, last post to pgsql-sql, i will post to novice ;) how can i change the "last_value" from a sequence? when i try this : medias=> update medias_media_id_seq set last_value = 2329; ERROR: You can't change sequence relation medias_media_id_seq thank you :) patrick