X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6858A475A80 for ; Mon, 21 Apr 2003 00:25:40 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id AE317474E42 for ; Mon, 21 Apr 2003 00:25:38 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 828EB43A89E; Mon, 21 Apr 2003 00:25:38 -0400 (EDT) X-Abuse-Report: abuse@teranews.com Message-ID: <525670e62aba2d75120f5657c77add8b@news.teranews.com> Date: Mon, 21 Apr 2003 04:25:44 GMT Lines: 21 From: foo2@on-spammers2.com X-Newsgroups: comp.databases.postgresql.sql Subject: Ok,, what about cache for SEQUENCE - where? how? Reply-To: the2@newsgroup2.com X-Newsreader: Forte Agent 1.92/32.572 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit To: pgsql-sql@postgresql.org X-Spam-Status: No, hits=-0.6 required=5.0 tests=BAYES_30,NO_REAL_NAME version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/337 X-Sequence-Number: 13038 The postgreSQL docs wave dire warnigns about the cache setting; if it is greater than one, apparently, sequences don't work (or at least, they work in a manner that isn't useful in the same way.) But the docs fail to point out where one could set, or even learn about, the cache setting. A search of the docs for "cache" turns up quite apparently useless references. So - where is the cache setting, and if that's only part of the answer, how does one see what it is set to? If it's set to two or more, how does one set it back to one so sequences will be guaranteed to work? Thanks for any answers. Walt Software Engineer Black Belt Systems pages: http://www.blackbeltsystems.com/ email: http://www.blackbeltsystems.com/contact.html