TODO item: Have psql show current values for a sequence

Поиск
Список
Период
Сортировка
Hi all,

These patch implements the TODO item: Have psql show current values
for a sequence.
Comments are welcome.

* Credits

The original patch were developed by Euler Taveira de Oliveira
<euler@timbira.com>
but how he is a little busy, he sends it to me and I made some changes
to satisfy
the TODO item above.

* Discussions

http://archives.postgresql.org/pgsql-hackers/2007-12/msg00102.php
http://archives.postgresql.org/pgsql-hackers/2007-12/msg00605.php

* Outputs

# \d foo_bar_seq
          Sequence "public.foo_bar_seq"
+---------------+---------+---------------------+
|    Column     |  Type   |        Value        |
+---------------+---------+---------------------+
| sequence_name | name    | foo_bar_seq         |
| last_value    | bigint  | 11                  |
| start_value   | bigint  | 1                   |
| increment_by  | bigint  | 1                   |
| max_value     | bigint  | 9223372036854775807 |
| min_value     | bigint  | 1                   |
| cache_value   | bigint  | 1                   |
| log_cnt       | bigint  | 31                  |
| is_cycled     | boolean | f                   |
| is_called     | boolean | t                   |
+---------------+---------+---------------------+

# \d+ foo_bar_seq
                 Sequence "public.foo_bar_seq"
+---------------+---------+---------------------+-------------+
|    Column     |  Type   |        Value        | Description |
+---------------+---------+---------------------+-------------+
| sequence_name | name    | foo_bar_seq         |             |
| last_value    | bigint  | 11                  |             |
| start_value   | bigint  | 1                   |             |
| increment_by  | bigint  | 1                   |             |
| max_value     | bigint  | 9223372036854775807 |             |
| min_value     | bigint  | 1                   |             |
| cache_value   | bigint  | 1                   |             |
| log_cnt       | bigint  | 31                  |             |
| is_cycled     | boolean | f                   |             |
| is_called     | boolean | t                   |             |
+---------------+---------+---------------------+-------------+

--
[]s
Dickson S. Guedes
--------------------------------------
Projeto Colmeia - Curitiba - PR
+55 (41) 3254-7130 ramal: 27
http://makeall.wordpress.com/
http://pgcon.postgresql.org.br/
http://planeta.postgresql.org.br/

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: \df displaying volatility
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Execution-time-sensitive timestamp regression tests