From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | jallen(at)americansavingslife(dot)com |
Subject: | BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT |
Date: | 2018-02-23 03:14:49 |
Message-ID: | 151935568942.1461.14623890240535309745@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15080
Logged by: jonathan allen
Email address: jallen(at)americansavingslife(dot)com
PostgreSQL version: 10.2
Operating system: Windows 10 x64
Description:
I'm trying to access a bigint column on windows using ecpg and I get the
following error:
SQL error: unsupported type "long long" on line x
I found ecpg_get_data() is the call generating the error, and there's a
block of code being skipped because HAVE_LONG_LONG_INT is not defined.
I found the following code in pg_config.h and tried adding the 3rd line
(#define HAVE_LONG_LONG_INT 1)...
/* Define to 1 if `long long int' works and is 64 bits. */
#if (_MSC_VER > 1200)
#define HAVE_LONG_LONG_INT_64 1
#define HAVE_LONG_LONG_INT 1
#endif
Then I tried recompiling postgres from source and copying over the new bin,
lib, include and shared directories...but no luck, my program is still
throwing the same error. I asked on the #postgresql irc channel and
RhodiumToad and xocolatl said that if I reported this as a bug paquier would
see this and he'd be the person to ask about it.
I'd really like to be able to get a fix going that I can compile and use
myself until a new public release is available - this bug has brought our
postgres migration to a standstill, it's a real show stopper. :(
Thank you for looking into this and hopefully pointing me in the right
direction. :)
-Jonathan
From | Date | Subject | |
---|---|---|---|
Next Message | Aman Bhadoriya | 2018-02-23 12:27:28 | Re: Installation problem |
Previous Message | 趙明春 | 2018-02-23 02:16:36 | Re: BUG #15076: postmaster crashes unexpectedly when using up arrow key in psql command |