|
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!! |
