Sequence Start number not dumped correctly

From: Reto Stamm <reto(at)retostamm(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Sequence Start number not dumped correctly
Date: 2002-11-02 02:07:26
Message-ID: 1036202846.3dc3335e12200@webmail.spamcop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Enbom 2002-11-04 19:24:09 Re: Wrong order of rows in result during regression test.
Previous Message Bruce Momjian 2002-11-01 22:28:30 Re: PostgreSQL Installation on SCO