Sequence Start number not dumped correctly - Mailing list pgsql-bugs

From Reto Stamm
Subject Sequence Start number not dumped correctly
Date
Msg-id 1036202846.3dc3335e12200@webmail.spamcop.net
Whole thread Raw
Responses Re: Sequence Start number not dumped correctly  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Mark Le Huray
Date:
Subject: Problem with a sequence being acted on by an on insert rule.
Next
From: Tom Lane
Date:
Subject: Re: like not using indexes in 7.3b5?