Обсуждение: Sequence Start number not dumped correctly

Hi,

When I have a sequence like this:

CREATE SEQUENCE "test_id_seq" start -32768 increment 1 maxvalue 32767 minvalue
-32768 cache 1;

and dump it using

pg_dump -s -c -f schema.txt testdb

it will show up in schema.txt like this:

CREATE SEQUENCE "test_id_seq" start 1 increment 1 maxvalue 32767 minvalue -32768
cache 1;

This makes me think that the start value is hardwired somewhere, and I wanted to
let you know. PostgreSQL is great! I use it for everything!

Thanks a lot

--reto

Reto Stamm <reto@retostamm.com> writes:
> When I have a sequence like this:
> CREATE SEQUENCE "test_id_seq" start -32768 increment 1 maxvalue 32767 minvalue
> -32768 cache 1;

> it will show up in schema.txt like this:

> CREATE SEQUENCE "test_id_seq" start 1 increment 1 maxvalue 32767 minvalue -32768
> cache 1;

How old is your Postgres?  It works here.

But note that there is probably also a select setval() for the sequence,
which is what *really* determines the starting value.

            regards, tom lane

Hello Tom,

I am sorry, I can not reproduce it any more either. I must have made a mistake.

It works perfectly (like the rest of Postgres). Thank you very much, I am sorry
for the waste of time.

Best regards

--reto

Quoting Tom Lane <tgl@sss.pgh.pa.us>:

> Reto Stamm <reto@retostamm.com> writes:
> > When I have a sequence like this:
> > CREATE SEQUENCE "test_id_seq" start -32768 increment 1 maxvalue 32767
> minvalue
> > -32768 cache 1;
>
> > it will show up in schema.txt like this:
>
> > CREATE SEQUENCE "test_id_seq" start 1 increment 1 maxvalue 32767 minvalue
> -32768
> > cache 1;
>
> How old is your Postgres?  It works here.
>
> But note that there is probably also a select setval() for the sequence,
> which is what *really* determines the starting value.
>
>             regards, tom lane