Received: from junk.nocrew.org ([212.73.17.42]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0DAgxp43084 for ; Sat, 13 Jan 2001 05:42:59 -0500 (EST) (envelope-from rojo@junk.nocrew.org) Received: from rojo by junk.nocrew.org with local (Exim 3.12 #1 (Debian)) for pgsql-sql@postgresql.org id 14HO9A-0005kK-00; Sat, 13 Jan 2001 11:42:56 +0100 To: pgsql-sql@postgresql.org Subject: new serial type From: Rolf Johansson Date: 13 Jan 2001 11:42:56 +0100 Message-ID: <7j3denn367.fsf@junk.nocrew.org> Lines: 7 User-Agent: Gnus/5.0803 (Gnus v5.8.3) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200101/123 X-Sequence-Number: 784 Is there some function to change the serial type to, instead of reading a next-value, read the maxium value in a column and then add x? If, for some reason, the sequence is not updated (when I'm doing COPY into a table), I'll have to recreate the sequence. Instead, it would be much more simple just to take the max()+x value for a new type of serial type. /Rolf