Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2GJwcx51453 for ; Fri, 16 Mar 2001 14:58:39 -0500 (EST) (envelope-from reedstrm@rice.edu) Received: by rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-sql@postgresql.org; Fri, 16 Mar 2001 13:58:24 -0600 (CST) Date: Fri, 16 Mar 2001 13:58:24 -0600 From: "Ross J. Reedstrom" To: Egbert Ellenkamp Cc: pgsql-sql@postgresql.org Subject: Re: update table sequence Message-ID: <20010316135824.C11713@rice.edu> Mail-Followup-To: Egbert Ellenkamp , pgsql-sql@postgresql.org References: <3ab203b3.242887724@newzilla.xs4all.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <3ab203b3.242887724@newzilla.xs4all.nl>; from e.ellenkamp@copernicus-it.nl on Fri, Mar 16, 2001 at 12:15:28PM +0000 X-Archive-Number: 200103/336 X-Sequence-Number: 2000 On Fri, Mar 16, 2001 at 12:15:28PM +0000, Egbert Ellenkamp wrote: > All, > > Is there a way I can set the sequence of a table equal to highest row > ID? > For example something like: > select setval('mytable_myrowid_seq',select max(myrowid) from mytable); So close! select setval('mytable_myrowid_seq',max(myrowid)) from mytable; Ross