| 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: | Whole Thread | Raw Message | 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 |