DB migration from Win (cygwin) to Linux (RH 7.2): 9223372036854775807 error

From: aagha(at)bigfoot(dot)com (aagha(at)bigfoot(dot)com)
To: pgsql-general(at)postgresql(dot)org
Subject: DB migration from Win (cygwin) to Linux (RH 7.2): 9223372036854775807 error
Date: 2002-11-01 16:33:35
Message-ID: 2eb5b441.0211010833.499d14fd@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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"
psql:cmsdb.sql:27: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit
index 'ratingcontentandtype_pkey' for table 'rating'

Any table with a serial decleration has this problem, and the serial
tables don't get built. I wondered if this was due to a MAXINT issue on
Linux, so I wrote a small C program wher I found out that the MAXINT and
LONG are both: 2147483647 -- The catch is that the same is true on my Win
box.

What's going on here, and what can I do to get around this problem?

We're on Postgres 7.1.

Thx,
Aurangzeb

--
aagha <at> bigfoot <dot> com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Guest 2002-11-01 16:33:57 Re: postgres on a FreeBSD 4.5 box
Previous Message Gregory Wood 2002-11-01 16:22:42 Re: postgres on a FreeBSD 4.5 box