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

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



Wed, 20 Apr 2005 00:33:35 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. D3 Linux 7.2 RH 6.1 error

2. Regression Test Failure on PG 7.2 under RH 7.2

3. Sequences crashing DB 7.2 on RH?

4. parser error: 9223372036854775807

5. Tcl_CreateSlave error (pg 7.1.2, RH 7.2)

6. PG 7.2 install on RH 7.0 dependency errors

7. Error in install of Oracle 8.1.17 on Linux 7.2 : Error in CreateOUIProcess (): 13

8. Redhat 7.2 and D3/Linux 7.2

9. Older Informix versions on RH 7.2

10. Installing 8.1.7 TNS adapters on RH 7.2

11. 9iR2 on RH 7.2 - runInstaller segmentation fault

12. ldap Oracle8.1.7.2 on RH 7.2


 
Powered by phpBB® Forum Software