From: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | sequences: cache_value, log_cnt, is_cycled columns |
Date: | 2003-10-27 20:53:50 |
Message-ID: | 20031027205350.64626.qmail@web40601.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-10-27 21:28:24 | Re: [GENERAL] sequences: cache_value, log_cnt, is_cycled columns |
Previous Message | Bruce Momjian | 2003-10-27 02:39:44 | Re: 7.4 compatibility question |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-10-27 20:55:22 | Re: Temporary tables and miscellaneous schemas |
Previous Message | Sean Chittenden | 2003-10-27 20:48:30 | Re: Temporary tables and miscellaneous schemas |