public inbox for [email protected]
help / color / mirror / Atom feedsequences: cache_value, log_cnt, is_cycled columns
2+ messages / 2 participants
[nested] [flat]
* sequences: cache_value, log_cnt, is_cycled columns
@ 2003-10-27 20:53 CSN <[email protected]>
2003-10-27 21:28 ` Re: [GENERAL] sequences: cache_value, log_cnt, is_cycled columns Tom Lane <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: CSN @ 2003-10-27 20:53 UTC (permalink / raw)
To: [email protected]
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [GENERAL] sequences: cache_value, log_cnt, is_cycled columns
2003-10-27 20:53 sequences: cache_value, log_cnt, is_cycled columns CSN <[email protected]>
@ 2003-10-27 21:28 ` Tom Lane <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-10-27 21:28 UTC (permalink / raw)
To: CSN <[email protected]>; +Cc: [email protected]; pgsql-docs
CSN <[email protected]> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-10-27 21:28 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-27 20:53 sequences: cache_value, log_cnt, is_cycled columns CSN <[email protected]>
2003-10-27 21:28 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox