Hi there,
i am trying to restore a database I have dumped from a postgres 8.0.4 power5 (64bit) machine onto another server with the same version and architecture.
It seems that recreating sequences does not work:
The command
CREATE SEQUENCE assignment_task_elements_seq2
INCREMENT BY 1
MAXVALUE 9223372036854775807
NO MINVALUE
CACHE 1;
Causes the following error: MINVALUE (1) must be less than MAXVALUE (-1)
The same command is working when I try to restore the dump to a postgres 8.0.3 intel 32bit machine.
What could be the problem here?
TIA, peter
Ps:
CREATE SEQUENCE assignment_task_elements_seq2
INCREMENT BY 1
MAXVALUE 922337203685477580 <- removed last “7”
NO MINVALUE
CACHE 1;
ERROR: MINVALUE (1) must be less than MAXVALUE (-858993460)
CREATE SEQUENCE assignment_task_elements_seq2
INCREMENT BY 1
MAXVALUE 92233720368547758 <- removed last “0”
NO MINVALUE
CACHE 1;
WORKS!!