X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 87369D1B536; Mon, 27 Oct 2003 21:28:55 +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 37745-01; Mon, 27 Oct 2003 17:28:25 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 8179DD1B517; Mon, 27 Oct 2003 17:28:23 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id h9RLSPit014278; Mon, 27 Oct 2003 16:28:25 -0500 (EST) To: CSN Cc: pgsql-general@postgresql.org, pgsql-docs@postgresql.org Subject: Re: [GENERAL] sequences: cache_value, log_cnt, is_cycled columns In-reply-to: <20031027205350.64626.qmail@web40601.mail.yahoo.com> References: <20031027205350.64626.qmail@web40601.mail.yahoo.com> Comments: In-reply-to CSN message dated "Mon, 27 Oct 2003 12:53:50 -0800" Date: Mon, 27 Oct 2003 16:28:24 -0500 Message-ID: <14277.1067290104@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/37 X-Sequence-Number: 2057 CSN writes: > I was just wondering, what are the "cache_value", > "long_cnt", and "is_cycled" sequence columns used for? cache_value: CACHE parameter from CREATE SEQUENCE is_cycled: CYCLE parameter from CREATE SEQUENCE log_cnt: internal use (number of values available without writing another WAL log entry, I think) Docs folk: is it useful to document the columns of sequence objects, or should we consider them all internal info? If they should be documented, where? I'm kind of inclined to make an entry in the "system catalogs" chapter, but I dunno what to title it ... regards, tom lane