Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pLNgM-0007GY-Tu for pgsql-odbc@arkaria.postgresql.org; Fri, 27 Jan 2023 12:18:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pLNgL-0005IM-T0 for pgsql-odbc@arkaria.postgresql.org; Fri, 27 Jan 2023 12:18:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pLNEv-0004Ie-GX for pgsql-odbc@lists.postgresql.org; Fri, 27 Jan 2023 11:49:53 +0000 Received: from relay.skbbank.ru ([213.5.80.70]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pLNEs-0006jD-A1 for pgsql-odbc@postgresql.org; Fri, 27 Jan 2023 11:49:52 +0000 Received: from mailserverpost.corp.skbbank.ru (dzr-fl.corp.skbbank.ru [172.21.107.35]) by relay.skbbank.ru (Postfix) with ESMTP id A57526A9673E for ; Fri, 27 Jan 2023 16:49:46 +0500 (+05) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=sinara-finance.ru; s=default; t=1674820186; bh=4fxz06qpGdpy33vPBjPR419iJGTiq0wBdvieuFEKWjA=; h=From:To:Subject:Date; b=2zBOFnv1DpgUSKe9yvuo7NiB8ORtqgptM58/6gJ6KSubl5970per+PRzQXAfatg9g agg6FAwky3RctsbSapCBq6tYZ1F3E1NcV6/aXtGljoye1eWBzd30WMV6sztEMMnN6j trZM4Y2FNlR93Ah3JcP5/mYruulPoTH8AlLPITLA= Received: by mailserverpost.corp.skbbank.ru (Postfix, from userid 1006) id 9E6021AA7; Fri, 27 Jan 2023 16:49:46 +0500 (+05) Received: from localhost (localhost [127.0.0.1]) by mailserverpost.corp.skbbank.ru (Postfix) with SMTP id 997C7101F422 for ; Fri, 27 Jan 2023 16:49:46 +0500 (+05) Received: from hq-exhc.corp.skbbank.ru (172.21.75.103) by 172.21.107.34 with smtp (Z-2 5.0) id norm-aa1640a2-9e38-11ed-ab43-000e1e3813a8; Fri, 27 Jan 2023 16:49:32 +0500 Received: from HQ-EXSRV04.corp.skbbank.ru (172.21.75.104) by HQ-EXSRV03.corp.skbbank.ru (172.21.75.103) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2375.18; Fri, 27 Jan 2023 16:49:32 +0500 Received: from HQ-EXSRV04.corp.skbbank.ru ([fe80::b9a7:5f40:1434:7b96]) by HQ-EXSRV04.corp.skbbank.ru ([fe80::b9a7:5f40:1434:7b96%4]) with mapi id 15.01.2375.018; Fri, 27 Jan 2023 16:49:32 +0500 From: "Chigodaev, Aleksandr" To: "pgsql-odbc@postgresql.org" Subject: an error while compiling psqlODBC on linux Thread-Topic: an error while compiling psqlODBC on linux Thread-Index: AdkyRPpYsrHAdHMFQ3+HaBw01y+n6g== Date: Fri, 27 Jan 2023 11:49:32 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.64.36.11] x-kse-serverinfo: HQ-EXSRV03.corp.skbbank.ru, 9 x-kse-attachmentfiltering-interceptor-info: protection disabled x-kse-antivirus-interceptor-info: scan successful x-kse-antivirus-info: Clean, bases: 1/27/2023 6:24:00 AM x-kse-bulkmessagesfiltering-scan-result: protection disabled Content-Type: multipart/alternative; boundary="_000_b30a62c82e6b45d99b5ff35b0be39a3dsinarafinanceru_" MIME-Version: 1.0 X-KLMS-Rule-ID: 4 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Status: not scanned, disabled by settings X-KLMS-AntiSpam-Interceptor-Info: not scanned X-KLMS-AntiPhishing: Clean, bases: 2023/01/27 10:58:00 X-KLMS-AntiVirus: Kaspersky Security for Linux Mail Server, version 8.0.3.30, bases: 2023/01/27 07:26:00 #20810262 X-KLMS-AntiVirus-Status: Clean, skipped List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_b30a62c82e6b45d99b5ff35b0be39a3dsinarafinanceru_ Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Dear psgql-odbc community! While following the instructions to compile psqlODBC from psqlodbc-13.02.00= 00.tar.gz ( I believe this is the latest version) https://odbc.postgresql.org/docs/unix-compilation.html I executed the configure command with the following flags: ./configure --with-unixodbc=3D/usr/local/unixODBC/bin --with-libpq=3D/usr/i= nclude/postgresql/libpq And then, I end up with the following error while executing the make comman= d =3D=3D=3D=3D=3D odbcapi30.c:120:1: error: conflicting types for 'SQLColAttribute'; have 'SQ= LRETURN(void *, SQLUSMALLINT, SQLUSMALLINT, void *, SQLSMALLINT, SQLSMAL= LINT *, void *)' {aka 'short int(void *, short unsigned int, short unsigne= d int, void *, short int, short int *, void *)'} 120 | SQLColAttribute(SQLHSTMT StatementHandle, | ^~~~~~~~~~~~~~~ In file included from psqlodbc.h:112, from odbcapi30.c:21: /usr/include/sql.h:613:24: note: previous declaration of 'SQLColAttribute' = with type 'SQLRETURN(void *, SQLUSMALLINT, SQLUSMALLINT, void *, SQLSMALL= INT, 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, | ^~~~~~~~~~~~~~~ make[1]: *** [Makefile:811: psqlodbcw_la-odbcapi30.lo] Error 1 make[1]: Leaving directory '/home/quant/psqlodbc/psqlodbc-13.02.0000' make: *** [Makefile:479: all] Error 2 =3D=3D=3D=3D=3D Would you be able to suggest anything to resolve this compilation error? I believe I have all the prerequisites installed correctly. psql -version psql (PostgreSQL) 14.6 (Ubuntu 14.6-0ubuntu0.22.04.1) I would be glad to provide additional details on request. Thanks in advance, Alexander --_000_b30a62c82e6b45d99b5ff35b0be39a3dsinarafinanceru_ Content-Type: text/html; charset="koi8-r" Content-Transfer-Encoding: quoted-printable

 

Dear psgql-odbc community!

 

 

While following the instructions to compile psqlODBC= from psqlodbc-13.02.0000.tar.gz ( I believe this is the latest version) &nbs= p;

 

https://odbc.postgresql.org/docs/unix-compilation.html

 

I executed the configure command with the following = flags:

 

./configure --with-unixodbc=3D/usr/local/unixODBC/bi= n --with-libpq=3D/usr/include/postgresql/libpq

 

And then, I end up with the following error while ex= ecuting the make command

 

=3D=3D=3D=3D=3D

 

odbcapi30.c:120:1: error: conflicting types for 'SQL= ColAttribute'; have 'SQLRETURN(void *, SQLUSMALLINT,  SQLUSMALLINT,&nb= sp; void *, SQLSMALLINT,  SQLSMALLINT *, void *)' {aka 'short int(void= *, short unsigned int,  short unsigned int,  void *, short int,  short int *, void *)'}

  120 | SQLColAttribute(SQLHSTMT StatementHandl= e,

      | ^~~~~~~~~~~~~~~

In file included from psqlodbc.h:112,

        &nbs= p;        from odbcapi30.c:21:

/usr/include/sql.h:613:24: note: previous declaratio= n of 'SQLColAttribute' with type 'SQLRETURN(void *, SQLUSMALLINT,  SQL= USMALLINT,  void *, SQLSMALLINT,  SQLSMALLINT *, SQLLEN *)' {aka = 'short int(void *, short unsigned int,  short unsigned int,  void *, short int,  short int *, long int *)'}<= /p>

  613 |     SQLRETURN = SQL_API SQLColAttribute(SQLHSTMT StatementHandle,

      |   &n= bsp;            = ;        ^~~~~~~~~~~~~~~

make[1]: *** [Makefile:811: psqlodbcw_la-odbcapi30.l= o] Error 1

make[1]: Leaving directory '/home/quant/psqlodbc/psq= lodbc-13.02.0000'

make: *** [Makefile:479: all] Error 2

 

=3D=3D=3D=3D=3D

 

Would you be able to suggest anything to resolve thi= s compilation error?

 

I believe I have all the prerequisites installed cor= rectly.

 

psql –version

psql (PostgreSQL) 14.6 (Ubuntu 14.6-0ubuntu0.22.04.1= )

 

I would be glad to provide additional details on req= uest.

 

Thanks in advance,

Alexander

--_000_b30a62c82e6b45d99b5ff35b0be39a3dsinarafinanceru_--