Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9433C64FCD7 for ; Fri, 5 Sep 2008 10:52:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07623-02 for ; Fri, 5 Sep 2008 10:52:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.225]) by postgresql.org (Postfix) with ESMTP id E513964FCBA for ; Fri, 5 Sep 2008 10:52:10 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so603599rvf.43 for ; Fri, 05 Sep 2008 06:52:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=ecodNI8lvYVfAn6R2rgzSISng9X1KFg/bF3oXXFgRhg=; b=JjlNdtkv2jXMCS72Lc2Rd/7p5COAuJgOo+HeeaSLE0gfw1voI5cdbYMqLjNdS4+jdu NS+6J9z8u0zAYkjPS1Rw8N1ojeNmE3X6kzp9DF111SPkdHRioK4DrbBU9A0LxHKmfhc7 8Q1l56QgzmuWNh4iDnj+kiiSggZQsLPnlpoy8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=H0MR+gFONbRcLZbRA2khiUvN36Uwps8pxjMlV8QDOe3au4zJ+TPnkkX4Ve5PFoFuYm iLwxdJELbUVi9ouFH8RhKTItGnUdcl+rS9pxCAzFQtKtyVHPaP4h2Rl2CYaFqmy09MN3 rGwZgKCFicAketQIQjLfRvG2MeO9eCgdCtQFI= Received: by 10.141.137.8 with SMTP id p8mr6620920rvn.163.1220622728596; Fri, 05 Sep 2008 06:52:08 -0700 (PDT) Received: by 10.141.74.11 with HTTP; Fri, 5 Sep 2008 06:52:08 -0700 (PDT) Message-ID: Date: Fri, 5 Sep 2008 07:52:08 -0600 From: "Scott Marlowe" To: "Claus Guttesen" Subject: Re: change max_value in sequence Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/41 X-Sequence-Number: 30134 On Fri, Sep 5, 2008 at 6:58 AM, Claus Guttesen wrote: > Hi. > > I have a table with a serial field defined with an older version of > postgresql (ver. 7). Back then max_value was 2147483647: > > select max_value from my_bid_seq ; > max_value > ------------ > 2147483647 > > How can I increase it? By updating the max_value-field? This is an > older thread and may have changed: > http://archives.postgresql.org/pgsql-admin/2002-12/msg00033.php That's the max for a regular int / serial type. You'll need to change it to bigserial / bigint which is 64 bits/ > > I'm running postgresql 8.3.1. Please update to 8.3.3