| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Mariano Reingart <mariano(at)nsis(dot)com(dot)ar> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: LibPqEasy, binary cursor, x86-64, fetch(int4) problem? |
| Date: | 2006-02-12 15:53:03 |
| Message-ID: | 20060212155303.GA68917@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Klostermann | 2006-02-12 22:59:10 | unsubscribe |
| Previous Message | Christoph Zwerschke | 2006-02-12 09:19:42 | Re: Finding the pqlib version |