On 1 Nov 2002 at 8:33, aagha@bigfoot.com 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"
Is that last field in that line? You are running into \r\n problem. Try some
simple scripts or dos2unix etc to convert the dump to unix style. There was a
sed one liner posted on the list few days back..
Bye
Shridhar
--
Williams and Holland's Law: If enough data is collected, anything may be proven
by statistical methods.
