* 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

Thu, 22 Jul 2004 15:23:47 +1000 (EST)
Gavin Sherry <swm@linuxworld.com.au>
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

Thu, 22 Jul 2004 07:49:34 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Completed TODO item?
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



Thu, 22 Jul 2004 13:21:06 +0100
Oliver Elphick <olly@lfix.co.uk>
Re: Completed TODO item?

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

Thu, 22 Jul 2004 08:24:27 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Completed TODO item?