Received: from femail7.sdc1.sfba.home.com (femail7.sdc1.sfba.home.com [24.0.95.87]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eADIsOs87501 for ; Mon, 13 Nov 2000 13:54:25 -0500 (EST) (envelope-from fspam@home.com) Received: from tajar ([24.1.6.224]) by femail7.sdc1.sfba.home.com (InterMail vM.4.01.03.00 201-229-121) with SMTP id <20001113185315.TXBW2350.femail7.sdc1.sfba.home.com@tajar>; Mon, 13 Nov 2000 10:53:15 -0800 From: Forest Wilkinson To: Dr Frog Cc: Subject: Re: Using a postgres table to maintain unique id? Date: Mon, 13 Nov 2000 10:53:58 -0800 Message-ID: <22e01tsb44dci6ath4tauffij41g2uona9@4ax.com> References: <3A102875.C545E345@noao.edu> <200011131840.eADIeTa20941@smartt.COM> In-Reply-To: <200011131840.eADIeTa20941@smartt.COM> X-Mailer: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/96 X-Sequence-Number: 127 On 13 Nov 2000 10:30:55 PST, Dr Frog wrote: >create sequnece seq_name ; > >there are additional options >start sql and type What are the "SQL" and "TYPE" options? I don't see reference to them in the docs. Can I use the TYPE option to create a sequence that's based in int8 (64 bit integer) instead of int4? That's exactly what I've been wanting! What version of postgres supports this?