Re: parser error: 9223372036854775807

"Aurangzeb M. Agha" <aagha(at)bigfoot(dot)com> writes:
> I'm having an issue moving my DB from from Win (Cygwin) to Linux 7.2. If
> I go from Linux to Cygwin, no probs, everything works fine, creates a new
> database beautifully.
> However, if I take the exact same DB (which contains data) and try the
> following on Linux:
> %> psql -d cmsdb -f cmsdb.sql
> I get the following:
> psql:cmsdb.sql:12: ERROR: parser: parse error at or near
> "9223372036854775807"

> Any table with a serial decleration has this problem, and the serial
> tables don't get built.

> We're on Postgres 7.1.

Apparently the Cygwin database is 7.2, which was the first release that
supported int8 sequences. Either update your Linux PG installation, or
be prepared to do some hand editing of the dump file.

regards, tom lane