Completed TODO item?

OK, good, marked as done.

---------------------------------------------------------------------------

Gavin Sherry wrote:

* Have psql show more information about sequences

template1=# \d foo_seq
Sequence "public.foo_seq"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean

That item seems to be done or have I missed something?

Gavin

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

On Thu, 2004-07-22 at 12:49, Bruce Momjian wrote:

OK, good, marked as done.

---------------------------------------------------------------------------

Gavin Sherry wrote:

* Have psql show more information about sequences

template1=# \d foo_seq
Sequence "public.foo_seq"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean

That item seems to be done or have I missed something?

That is not changed since 7.4.

Surely the TODO item means that we should be able to see the values of
all those columns in the sequence. in 7.4, we just get:

bray=# \ds
List of relations
Schema | Name | Type | Owner
--------+------------------------+----------+-------
prod | address_id_seq | sequence | olly
...

so you can't tell where the sequence is, without doing:

bray=# select * from address_id_seq;
sequence_name | last_value | increment_by | max_value |
min_value | cache_value | log_cnt | is_cycled | is_called
----------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
address_id_seq | 8490 | 1 | 9223372036854775807
| 1 | 1 | 0 | f | t

Oliver Elphick

Yep, wording updated:

* Have psql show current values for a sequence

---------------------------------------------------------------------------

Oliver Elphick wrote:

On Thu, 2004-07-22 at 12:49, Bruce Momjian wrote:

OK, good, marked as done.

---------------------------------------------------------------------------

Gavin Sherry wrote:

* Have psql show more information about sequences

template1=# \d foo_seq
Sequence "public.foo_seq"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean

That item seems to be done or have I missed something?

That is not changed since 7.4.

Surely the TODO item means that we should be able to see the values of
all those columns in the sequence. in 7.4, we just get:

bray=# \ds
List of relations
Schema | Name | Type | Owner
--------+------------------------+----------+-------
prod | address_id_seq | sequence | olly
...

so you can't tell where the sequence is, without doing:

bray=# select * from address_id_seq;
sequence_name | last_value | increment_by | max_value |
min_value | cache_value | log_cnt | is_cycled | is_called
----------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
address_id_seq | 8490 | 1 | 9223372036854775807
| 1 | 1 | 0 | f | t

Oliver Elphick

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073