Thread: comp.databases.postgresql.general

comp.databases.postgresql.general

From
ceco@noxis.net (ceco)
Date:
hallo,

i have the following problem: i migrate from mysql to postgresql, but
a problem arised when porting the data - there are int unsigned
fields, which i can't convert to postgre without using int8, because
there is data above 2^31 (and of course below 2^32) which fits in
mysql's int unsigned, but not in postgre's int4

(int8 is not applicable, because of the speed, and quite much code
have to ported so that the indexes to be used - i saw that problem in
the documentation)

any comments are welcome