Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-docspgsql-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

pgsql-docs by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group