Received: from wm7.jersey.juno.com (wm7.jersey.juno.com [64.136.16.227]) by postgresql.org (Postfix) with ESMTP id 4F4CC4759C5 for ; Mon, 4 Mar 2002 13:03:03 -0500 (EST) Received: from cookie.juno.com by cookie.juno.com for <"/TkDBi7JJ2b6tmw2z88AACev2PZl0f2KvxLZl030e7FEK074dQ2mRg=="> Received: (from pricem@juno.com) by wm7.jersey.juno.com (jqueuemail) id GU3W62SQ; Mon, 04 Mar 2002 13:02:37 EST X-Original-From: "Matthew Price" Date: Mon, 4 Mar 2002 18:02:37 GMT To: pgsql-sql@postgresql.org Subject: Changing sequence cache X-Mailer: Juno Webmail Version 1.0 From: Matthew Price Message-Id: <20020304.130237.19811.60399@wm7.jersey.juno.com> X-Archive-Number: 200203/36 X-Sequence-Number: 6918 Howdy, I already have a sequence named customers_custid_seq I would like to increase the cache setting some. How can i alter the cache after the sequence has already been created? Trying: update customer_custid_seq set cache=5; Gives this: ERROR: You can't change sequence relation customer_custid_seq Thanks for any help, Matthew ________________________________________________________________ GET INTERNET ACCESS FROM JUNO! Juno offers FREE or PREMIUM Internet access for less! Join Juno today! For your FREE software, visit: http://dl.www.juno.com/get/web/.