On Sat, Feb 11, 2006 at 08:28:25PM -0300, Mariano Reingart wrote:
> Hi, I recently moved a simple application from a 32bit Intel to a new AMD64
> server (migrated from Postgres 7.2 to 8.1.2 and LibPqEasy 3.0.4), running
> Slamd64 (Slackware port to the AMD64). Everything compiled just fine but
> the applicattion didn't work as expected.
> When I look into the tables (with psql) I see strange values in int4
> columns like ( 16777216, 402653184, 1124073472, ...) instead of normal ones
> (1, 24, 67)
Convert the numbers to hex and they don't look so strange:
1 = 0x01
24 = 0x18
67 = 0x43
16777216 = 0x01000000
402653184 = 0x18000000
1124073472 = 0x43000000
That ought to hint at what's happening.
--
Michael Fuhr