From: | "Aurangzeb M(dot) Agha" <aagha(at)bigfoot(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | parser error: 9223372036854775807 |
Date: | 2002-10-31 11:04:44 |
Message-ID: | Pine.LNX.4.44.0210310258290.29216-100000@cinemaspace.berkeley.edu |
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
--
Aurangzeb M. Agha | Email : aagha(at)bigfoot(dot)com
| Home : +3 010 8959.558
34 Nafsika St. | Direct: +3 010 8995.875
Voula 16673 | Mobile: TBD
Greece | Voice : 415 412 4234 (US Only)
| e-Fax : 978 246.0770
PGP ID: 0x68B3A763 |
"Those who would give up essential liberty to purchase a little
temporary safety deserve neither liberty nor safety."
- Benjamin Franklin
From | Date | Subject | |
---|---|---|---|
Next Message | Henshall, Stuart - Design & Print | 2002-10-31 13:26:16 | Re: PROBLEM with inserting a duplicate key into unique |
Previous Message | Arunvijai | 2002-10-31 09:36:46 | Re: comamnds |