Reto Stamm <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
