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>:
Show quoted text
Reto Stamm <reto@retostamm.com> writes:
When I have a sequence like this:
CREATE SEQUENCE "test_id_seq" start -32768 increment 1 maxvalue 32767minvalue
-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