From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | aagha(at)bigfoot(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: parser error: 9223372036854775807 |
Date: | 2002-11-07 15:25:25 |
Message-ID: | 200211071525.gA7FPPr11842@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Try checking 'long long' to see if they are the same sizes. I bet they
aren't. I assume this is i386 Linux.
---------------------------------------------------------------------------
Aurangzeb M. Agha wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2002-11-07 15:27:30 | Re: DB migration from Win (cygwin) to Linux (RH 7.2): 9223372036854775807 error |
Previous Message | Andrew Sullivan | 2002-11-07 15:18:33 | Re: Question about foreign key |