X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3969ED1B50E for ; Mon, 27 Oct 2003 20:54:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 27956-09 for ; Mon, 27 Oct 2003 16:53:51 -0400 (AST) Received: from web40601.mail.yahoo.com (web40601.mail.yahoo.com [66.218.78.138]) by svr1.postgresql.org (Postfix) with SMTP id 91ED5D1B559 for ; Mon, 27 Oct 2003 16:53:49 -0400 (AST) Message-ID: <20031027205350.64626.qmail@web40601.mail.yahoo.com> Received: from [208.157.46.80] by web40601.mail.yahoo.com via HTTP; Mon, 27 Oct 2003 12:53:50 PST Date: Mon, 27 Oct 2003 12:53:50 -0800 (PST) From: CSN Subject: sequences: cache_value, log_cnt, is_cycled columns To: pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=BAYES_30, FROM_ENDS_IN_NUMS, FROM_HAS_UNDERLINE_NUMS X-Spam-Level: X-Archive-Number: 200310/1320 X-Sequence-Number: 51392 I was just wondering, what are the "cache_value", "long_cnt", and "is_cycled" sequence columns used for? I couldn't find anything in the docs or Google. select * from test_id_seq; sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called ---------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+----------- test_id_seq | 1 | 1 | 9223372036854775807 | 1 | 1 | 1 | f | f (1 row) __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/