From: | "Peter Alberer" <peter(dot)alberer(at)wu-wien(dot)ac(dot)at> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem restoring db-dump on Postgres 8.0.4 Power5 |
Date: | 2006-01-03 10:24:57 |
Message-ID: | 200601031025.k03AP5xA047130@rumba.wu-wien.ac.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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!!
From | Date | Subject | |
---|---|---|---|
Next Message | xiapw | 2006-01-03 11:01:24 | who has some document about extending postgresql |
Previous Message | Andrew - Supernews | 2006-01-03 06:32:04 | Re: INSERT OR UPDATE |