postgresql-interfaces/psqlodbc GitHub issues and pull requests (mirror)  
help / color / mirror / Atom feed
[postgresql-interfaces/psqlodbc] issue #16: [psqlodbc-REL-16_00_0004][Postgres 15 5][Debian][unixODBC] Need to add CPPFLAGS="-DSQLCOLATTRIBUTE_SQLLEN" to configure to get it to compile
6+ messages / 2 participants
[nested] [flat]

* [postgresql-interfaces/psqlodbc] issue #16: [psqlodbc-REL-16_00_0004][Postgres 15 5][Debian][unixODBC] Need to add CPPFLAGS="-DSQLCOLATTRIBUTE_SQLLEN" to configure to get it to compile
@ 2024-05-13 09:49  "jboakye (@jboakye)" <[email protected]>
  0 siblings, 0 replies; 6+ messages in thread

From: jboakye (@jboakye) @ 2024-05-13 09:49 UTC (permalink / raw)
  To: postgresql-interfaces/psqlodbc <[email protected]>

Otherwise we get the error below. Same issue with previous releases.

odbcapi30.c:120:1: error: conflicting types for 'SQLColAttribute'; have 'SQLRETURN(void *, SQLUSMALLINT,  SQLUSMALLINT,  void *, SQLSMALLINT,  SQLSMALLINT *, void *)' {aka 'short int(void *, short unsigned int,  short unsigned int,  void *, short int,  short int *, void *)'}
  120 | SQLColAttribute(SQLHSTMT StatementHandle,
      | ^~~~~~~~~~~~~~~
In file included from psqlodbc.h:145,
                 from odbcapi30.c:21:
/usr/local/include/sql.h:613:24: note: previous declaration of 'SQLColAttribute' with type 'SQLRETURN(void *, SQLUSMALLINT,  SQLUSMALLINT,  void *, SQLSMALLINT,  SQLSMALLINT *, SQLLEN *)' {aka 'short int(void *, short unsigned int,  short unsigned int,  void *, short int,  short int *, long int *)'}
  613 |     SQLRETURN  SQL_API SQLColAttribute(SQLHSTMT StatementHandle,
      |                        ^~~~~~~~~~~~~~~


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [postgresql-interfaces/psqlodbc] issue #16: [psqlodbc-REL-16_00_0004][Postgres 15 5][Debian][unixODBC] Need to add CPPFLAGS="-DSQLCOLATTRIBUTE_SQLLEN" to configure to get it to compile
@ 2024-05-13 10:56  "davecramer (@davecramer)" <[email protected]>
  4 siblings, 0 replies; 6+ messages in thread

From: davecramer (@davecramer) @ 2024-05-13 10:56 UTC (permalink / raw)
  To: postgresql-interfaces/psqlodbc <[email protected]>

@jboakye when did it stop compiling ?

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [postgresql-interfaces/psqlodbc] issue #16: [psqlodbc-REL-16_00_0004][Postgres 15 5][Debian][unixODBC] Need to add CPPFLAGS="-DSQLCOLATTRIBUTE_SQLLEN" to configure to get it to compile
@ 2024-05-13 11:44  "jboakye (@jboakye)" <[email protected]>
  4 siblings, 0 replies; 6+ messages in thread

From: jboakye (@jboakye) @ 2024-05-13 11:44 UTC (permalink / raw)
  To: postgresql-interfaces/psqlodbc <[email protected]>

@davecramer  I only downloaded it a few days ago and found the issue with it. This is my first time having to compile it on debian and standalone from the postgres source tree (I think) and in general I have not had to deal with this driver for over 4 years or so as I was too busy to work on this project that requires it. 

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [postgresql-interfaces/psqlodbc] issue #16: [psqlodbc-REL-16_00_0004][Postgres 15 5][Debian][unixODBC] Need to add CPPFLAGS="-DSQLCOLATTRIBUTE_SQLLEN" to configure to get it to compile
@ 2024-05-13 11:46  "jboakye (@jboakye)" <[email protected]>
  4 siblings, 0 replies; 6+ messages in thread

From: jboakye (@jboakye) @ 2024-05-13 11:46 UTC (permalink / raw)
  To: postgresql-interfaces/psqlodbc <[email protected]>

I tried the 8xx release also in the last few days and found the same issue.

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [postgresql-interfaces/psqlodbc] issue #16: [psqlodbc-REL-16_00_0004][Postgres 15 5][Debian][unixODBC] Need to add CPPFLAGS="-DSQLCOLATTRIBUTE_SQLLEN" to configure to get it to compile
@ 2024-05-13 11:49  "jboakye (@jboakye)" <[email protected]>
  4 siblings, 0 replies; 6+ messages in thread

From: jboakye (@jboakye) @ 2024-05-13 11:49 UTC (permalink / raw)
  To: postgresql-interfaces/psqlodbc <[email protected]>

This is the actual compiler invocation if that helps:
libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I -I/d/postgres/postgresql_15_5/src/bin/include -I/d/postgres/postgresql_15_5/src/bin/include/postgresql/internal -I/usr/local/pgsql/include -I/usr/local/pgsql/include/internal -DUNICODE_SUPPORT -g -O2 -Wall -MT psqlodbcw_la-odbcapi30.lo -MD -MP -MF .deps/psqlodbcw_la-odbcapi30.Tpo -c odbcapi30.c  -fPIC -DPIC -o .libs/psqlodbcw_la-odbcapi30.o

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [postgresql-interfaces/psqlodbc] issue #16: [psqlodbc-REL-16_00_0004][Postgres 15 5][Debian][unixODBC] Need to add CPPFLAGS="-DSQLCOLATTRIBUTE_SQLLEN" to configure to get it to compile
@ 2024-05-13 11:55  "jboakye (@jboakye)" <[email protected]>
  4 siblings, 0 replies; 6+ messages in thread

From: jboakye (@jboakye) @ 2024-05-13 11:55 UTC (permalink / raw)
  To: postgresql-interfaces/psqlodbc <[email protected]>

I did bootstrap and then configure prior:
./configure   --with-unixodbc=/usr/local/bin  --with-libpq=/d/postgres/postgresql_15_5/src/bin

Everything works fine with this configure line (and after replacing _strdup with strdup in psqlodbc.h):
./configure CPPFLAGS="-DSQLCOLATTRIBUTE_SQLLEN"  --with-unixodbc=/usr/local/bin  --with-libpq=/d/postgres/postgresql_15_5/src/bin

^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2024-05-13 11:55 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-13 09:49 [postgresql-interfaces/psqlodbc] issue #16: [psqlodbc-REL-16_00_0004][Postgres 15 5][Debian][unixODBC] Need to add CPPFLAGS="-DSQLCOLATTRIBUTE_SQLLEN" to configure to get it to compile "jboakye (@jboakye)" <[email protected]>
2024-05-13 10:56 ` "davecramer (@davecramer)" <[email protected]>
2024-05-13 11:44 ` "jboakye (@jboakye)" <[email protected]>
2024-05-13 11:46 ` "jboakye (@jboakye)" <[email protected]>
2024-05-13 11:49 ` "jboakye (@jboakye)" <[email protected]>
2024-05-13 11:55 ` "jboakye (@jboakye)" <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox