Problem restoring db-dump on Postgres 8.0.4 Power5

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