X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B3ECBD1B75C for ; Fri, 25 Jun 2004 15:27:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45396-04 for ; Fri, 25 Jun 2004 18:27:08 +0000 (GMT) Received: from ecintweb.eldocomp.com (smtp.eldocomp.com [205.159.99.8]) by svr1.postgresql.org (Postfix) with ESMTP id A2267D1B2BD for ; Fri, 25 Jun 2004 15:27:05 -0300 (ADT) Received: by ecintweb.eldocomp.com with XWall v3.29f ; Fri, 25 Jun 2004 11:27:05 -0700 From: Naomi Walker To: "pgsql-admin@postgresql.org" Reply-To: "nwalker@eldocomp.com" Subject: Sequence Number question Date: Fri, 25 Jun 2004 11:27:03 -0700 X-Assembled-By: XWall v3.29f Message-ID: <40DC6E77.1070908@eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=EXCUSE_16, LINES_OF_YELLING, TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200406/407 X-Sequence-Number: 14067 We are using Postgres 7.3.2 on a Solaris box. When I dump a schema with a SEQUENCE in it, it shows the MAXVAL as=20 2,147,483,647. Is it possible to set this number higher? When we get to maxval, does it wrap?=20=20 --=20 ------------------------------------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100=20 ------------------------------------------------------------------------- Thought is the blossom; language the bud; action the fruit behind it. - Ralph Waldo Emerson=20 -------------------------------------------------------------------------= =20 -- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to w= hom it is addressed, and may contain information that is privileged, confid= ential and exempt from disclosure under applicable law. If you are not the = intended addressee, nor authorized to receive for the intended addressee, y= ou are hereby notified that you may not use, copy, disclose or distribute t= o anyone the message or any information contained in the message. If you ha= ve received this message in error, please immediately advise the sender by = reply email, and delete the message. Thank you.