sequences: cache_value, log_cnt, is_cycled columns - Mailing list pgsql-general

From CSN
Subject sequences: cache_value, log_cnt, is_cycled columns
Date
Msg-id 20031027205350.64626.qmail@web40601.mail.yahoo.com
Whole thread Raw
Responses Re: sequences: cache_value, log_cnt, is_cycled columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: Temporary tables and miscellaneous schemas
Next
From: Bruce Momjian
Date:
Subject: Re: Temporary tables and miscellaneous schemas