| 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: | Whole Thread | Raw Message | 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 |