Problem restoring db-dump on Postgres 8.0.4 Power5

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

Responses

Browse pgsql-general by date

  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