Re: [GENERAL] sequences: cache_value, log_cnt, is_cycled columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: [GENERAL] sequences: cache_value, log_cnt, is_cycled columns
Date: 2003-10-27 21:28:24
Message-ID: 14277.1067290104@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

CSN <cool_screen_name90001(at)yahoo(dot)com> 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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Stefan Weiss 2003-10-27 22:09:37 INNER JOINS in sql-select.html
Previous Message CSN 2003-10-27 20:53:50 sequences: cache_value, log_cnt, is_cycled columns

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2003-10-27 21:58:50 grant all to database inheritence
Previous Message Sean Chittenden 2003-10-27 21:17:48 Re: Temporary tables and miscellaneous schemas