DevHeads.net

Postings by AYahorau

Re: psqlodbc: No memory available to store statement

Hello Hiroshi,

I found a possible approach to overcome this issue.
It is necessary to explicitly specify the path to libpq.so library within
LD_LIBRARY_PATH environment variable before running the configure command.

In this case conftest program finds the desired libpq and in this case the
generated config.h file contains proper defines:
/* The size of `long', as computed by sizeof. */
#define SIZEOF_LONG 8

/* The size of `long int', as computed by sizeof. */
#define SIZEOF_LONG_INT 8

/* The size of `void *', as computed by sizeof.

psqlodbc: No memory available to store statement

Hello PostgreSQL Community!

I widely use psqlodb driver with unixODBC manager on my SLES12 linux
machine.
Not very long ago I updated psqlodbc driver from 10.03.0000 to the
latest one 11.01.0000 .
I use unixODBC-2.3.6-7.9.1.x86_64 package installed from YAST setup and
configurational tool and configure, build, and install psqlodbc from the
source code in the same way as for psqlodbc 10.03.0000:

autoreconf -i
./configure --prefix=path_to_install --with-libpq=path_to_pg_config
--with-unixodbc=path_to_odbc_config
make
make install

In my program I use quite common ODBC functions to

configuration of psqlodbc and libpq

Hello!
I have a question.

I built and installed PostgreSQL on my system from the source code from
<a href="https://www.postgresql.org/ftp/source/" title="https://www.postgresql.org/ftp/source/">https://www.postgresql.org/ftp/source/</a> .
Moreover I built psqlodbc from the source code from
<a href="https://www.postgresql.org/ftp/odbc/versions/src/" title="https://www.postgresql.org/ftp/odbc/versions/src/">https://www.postgresql.org/ftp/odbc/versions/src/</a> .
So psqlodbcw.so library is specified as a Driver in my unixODBC
configuration.

But I have a problem. On the one hand all the PostgreSQL-related
libraries are located in /usr/lib directory. On the other hand libpq5 rpm
package is installed on my machine which locates its libraries in
/usr/lib64 directory.

ODBC cliens is hanging if network connection is broken

Hello PostgreSQL Community!

I downloaded and installed the latest version of PostgreSQL from
<a href="https://www.postgresql.org/ftp/source/v10.4/" title="https://www.postgresql.org/ftp/source/v10.4/">https://www.postgresql.org/ftp/source/v10.4/</a> on my SLES 12 system.
Here is my configuration of unixODBC:

odbcinst,ini
[PostgreSQL]
Description=PostgreSQL ODBC driver
Driver=/usr/local/lib/psqlodbcw.so
FileUsage=1

odbc.ini
[sles12-1]
Description = PostgreSQL connection to rtpdb
Driver = PostgreSQL
Database = rtpdb
Servername = sles12-1
Username =
Password =
Port = 5432
Protocol = 7.4+
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ConnSettings =

As a Driver in odbcinst.ini I specified the p