gmane.comp.db.postgresql.odbc

Configure script unable to find PgSQL dir

Joe Tseng — 2012-05-23T13:56:43

I'm attempting to compile and install this from source but I'm getting a "library not found" error:

# ls -l /export/appl/pkgs/pgsql
total 4
lrwxrwxrwx   1 root     other          6 May 23 09:29 latest -> v9.1.3
drwxr-xr-x   6 root     other        512 May  8 16:02 v9.1.3

./configure \
  --prefix=/export/appl/pkgs/psqlodbc/v09.01.0100 \
  --with-libpq=/export/appl/pkgs/pgsql/latest \
  --with-unixodbc=/export/appl/pkgs/unixodbc/latest \
  --enable-unicode \
  --host=sparc-sun-solaris2.10 \
  --disable-openssl
...
checking for PQconnectdb in -lpq... no
configure: error: libpq library not found

I also configured using --without-libpq and the package was made and installed correctly, but I don't think it knows how to connect:

# ./isql pidcim11 odbcuser xxx
[ISQL]ERROR: Could not SQLConnect

If this is not the right address to ask questions is there a forum that I can post my problem to?

thx,

 - Joe


If you type "Google" into Google, you can break the Internet.  -- Jen Barber

[ psqlodbc-Bugs-1011196 ] Cannot insert very large blobs

2012-05-22T14:13:34

Bugs item #1011196, was opened at 2012-05-21 21:57
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011196&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Michael Vitale (pgdude)
Assigned to: Nobody (None)
Summary: Cannot insert very large blobs

Initial Comment:
I can use the PostgreSQL ODBC driver to insert a blob (bytea) of 128 megabytes, but when I try to insert one that is 399 megabytes it fails with:

Query buffer overflow in copy_statement_with_parameters

The actuall call that fails is SQLExecute.


Here is the snippet of code I see in convert.c:

enlarge_query_statement(QueryBuild *qb, size_t newsize)
{
size_tnewalsize = INIT_MIN_ALLOC;
CSTR func = "enlarge_statement";

if (qb->str_size_limit > 0 && qb->str_size_limit < (int) newsize)
{
         < here is the branch that is executed>

----------------------------------------------------------------------

Comment By: Michael Vitale (pgdude)
Date: 2012-05-2

[ psqlodbc-Bugs-1011196 ] Cannot insert very large blobs

2012-05-22T14:13:04

Bugs item #1011196, was opened at 2012-05-21 21:57
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011196&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Michael Vitale (pgdude)
Assigned to: Nobody (None)
Summary: Cannot insert very large blobs

Initial Comment:
I can use the PostgreSQL ODBC driver to insert a blob (bytea) of 128 megabytes, but when I try to insert one that is 399 megabytes it fails with:

Query buffer overflow in copy_statement_with_parameters

The actuall call that fails is SQLExecute.


Here is the snippet of code I see in convert.c:

enlarge_query_statement(QueryBuild *qb, size_t newsize)
{
size_tnewalsize = INIT_MIN_ALLOC;
CSTR func = "enlarge_statement";

if (qb->str_size_limit > 0 && qb->str_size_limit < (int) newsize)
{
         < here is the branch that is executed>

----------------------------------------------------------------------

Comment By: Michael Vitale (pgdude)
Date: 2012-05-2

cannot copy very large bytea data

Michael Vitale — 2012-05-22T13:57:29

I am able to copy a row with a 127megabyte column, but not with one that is 399 megabytes.

Here is the log output of the one that fails:

[4272-42.487]SQL_VARBINARY: about to call convert_to_pgbinary, used = 399966009
[4272-42.488]STATEMENT ERROR: func=enlarge_statement, desc='', errnum=1, errmsg='Query buffer allocate error in copy_statement_with_parameters'
[4272-42.496]CONN ERROR: func=enlarge_statement, desc='', errnum=0, errmsg='(NULL)'
[4272-42.499]retval=-1
[4272-42.500][[SQLGetDiagFieldW]] Handle=(3,08F47DD0) Rec=1 Id=4 info=(09BF6788,12)
[4272-42.500]PGAPI_GetDiagField entering rec=1[4272-42.500]ER_ReturnError: status = 1, msg = #Query buffer allocate error in copy_statement_with_parameters#
[4272-42.501]         szSqlState = 'HY000',len=61, szError='(null)'
[4272-42.501]PGAPI_GetDiagField exiting 0

[ psqlodbc-Bugs-1011196 ] Cannot insert very large blobs

2012-05-21T22:13:19

Bugs item #1011196, was opened at 2012-05-21 21:57
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011196&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Michael Vitale (pgdude)
Assigned to: Nobody (None)
Summary: Cannot insert very large blobs

Initial Comment:
I can use the PostgreSQL ODBC driver to insert a blob (bytea) of 128 megabytes, but when I try to insert one that is 399 megabytes it fails with:

Query buffer overflow in copy_statement_with_parameters

The actuall call that fails is SQLExecute.


Here is the snippet of code I see in convert.c:

enlarge_query_statement(QueryBuild *qb, size_t newsize)
{
size_tnewalsize = INIT_MIN_ALLOC;
CSTR func = "enlarge_statement";

if (qb->str_size_limit > 0 && qb->str_size_limit < (int) newsize)
{
         < here is the branch that is executed>

----------------------------------------------------------------------

Date: 2012-05-21 22:13

Message:
[4272-42.487]SQL_V

[ psqlodbc-Bugs-1011196 ] Cannot insert very large blobs

2012-05-21T21:57:28

Bugs item #1011196, was opened at 2012-05-21 21:57
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011196&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Michael Vitale (pgdude)
Assigned to: Nobody (None)
Summary: Cannot insert very large blobs

Initial Comment:
I can use the PostgreSQL ODBC driver to insert a blob (bytea) of 128 megabytes, but when I try to insert one that is 399 megabytes it fails with:

Query buffer overflow in copy_statement_with_parameters

The actuall call that fails is SQLExecute.


Here is the snippet of code I see in convert.c:

enlarge_query_statement(QueryBuild *qb, size_t newsize)
{
size_tnewalsize = INIT_MIN_ALLOC;
CSTR func = "enlarge_statement";

if (qb->str_size_limit > 0 && qb->str_size_limit < (int) newsize)
{
         < here is the branch that is executed>

----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/

Update For Outdated Win98

BGoebel — 2012-05-08T11:38:07

I admit, nowadays an exotic szenario:

Running a PostgreSQL client on an Windows 98 machine.

The 9.1 pSQLOdbc Driver uses some Kernel32.DLL functions which were
introduced with  WindowsXP.
such as TryEnterCriticalSection().

I updated Windows 98 with KernelEx 4.5.2 http://kernelex.sourceforge.net/
and the brandnew 2011 pSQLOdbc driver runs with our application without a
problem until now. We are using UTF8 Charsets with the psqlodbca.dll, UTF 16
with psqlodbcw.dll might be an issue.

KernelEx is a compatibility layer for running Win2000+ apps.

I have tested it with Win98 running in a VM, but i am sure pSQLODBC will
work with a real machine too.

Special thanks go to Hiroshi Inoue for his hint.
 




--
View this message in context: http://postgresql.1045698.n5.nabble.com/Update-For-Outdated-Win98-tp5693458.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.

Advanced Options - OID

Jan-Peter Seifert — 2012-04-23T11:21:59

Hello,

if 'Advanced Options' -> 'OID Options' -> 'Show Column' is activated ODBC
function SQLColumns() retrieves one more row than expected if you use the function's filter ColumnName.
If you check for the existence of a column that does not exist you get one
instead of no result row.
If you check for the existence of a column that does exist you get two instead of one row and the correct row is the second and not the first one.

Could you check this, please?

Thank you very much,

Peter Seifert

UPDATE table via ODBC fails.

Ken Benson — 2012-04-11T22:01:36

I have a fairly straightforward routine which uses an ODBC connection to 
do 4 steps:

  * DROP TABLE IF EXISTS tmp_rxpurge
  * CREATE TABLE tmp_rxpurge (rxnum VARCHAR(300),dt_wrt DATE,dt_lastfill
    DATE,dt_lastact DATE, b_purge BOOLEAN)
  * INSERT INTO tmp_rxpurge (rxnum,dt_wrt,b_purge) SELECT
    "RXNUM","DATE",'f' FROM rx
  * UPDATE tmp_rxpurge as t SET dt_lastfill = rf.dt_lastfill FROM
    (SELECT "RXNUM" AS rxnum, Max("DATE") as dt_lastfill FROM
    transactions GROUP BY "RXNUM") as rf WHERE rf.rxnum=t.rxnum


The first three commands are executed perfectly as expected.
The update fails to do anything.
There is no error generated.
I have enabled 'logging' in the ODBC connector - and I don't see 
anything out of the ordinary in the short-log. (The long-log - I have no 
idea what all that stuff means.)

If I copy that last command into a psql window - it executes - and works 
fine.

But - it will not work via the ODBC connector.

What's going on?

Ken

Passing numeric Bind variables to ODBC driver convers to "Double precision"

Barry Bell — 2012-04-09T14:35:10

 Using the lastest of ODBC ANSI driver for windows 32bit ver 9.00.03  Calling from MS VFP 9.0

 public nvar as interger
 nvar=1
 running the following sql:
 "( select function_pkg(?nvar) "

 The bind variable nvar will show in postgres as "Double Precision"  format instead of integer(or numeric)

 Is there a setting on the ODBC driver for incoming vairables?

Very basic question from a beginner

Jean MAURICE — 2012-04-08T14:03:10

HI,

I am very new to PostGreSql and ODBC but an 'expert' in Visual Foxpro. I wanted 
to try VFP as a client of PostGres. My laptop is under W7-64. I 'installed' the 
ODBC driver via Stack Builder. All things seemed to work well but nothing 
appears in th ODBC Sources Manager (I apologize I must guess the english names 
from the french ones ...).

What have I missed ?

Thanks in advance.
Best regards
The Foxil

[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

2012-03-28T03:28:24

Bugs item #1010500, was opened at 2008-10-28 14:09
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

  Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
  Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
  Dim Tbl As New DataTable
  DA.Fill(zTbl)

When I inspect the values, they differ:

  ?tbl.Rows(0).Item(0).ToString
  "e964684f-87fe-49d9-9b87-137cc83165ea"
  ?tbl.Rows(0).Item(1).ToString
  "00390065-0036-0034-3600-380034006600"

[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

2012-03-27T13:41:37

Bugs item #1010500, was opened at 28/10/2008 15:09
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

  Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
  Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
  Dim Tbl As New DataTable
  DA.Fill(zTbl)

When I inspect the values, they differ:

  ?tbl.Rows(0).Item(0).ToString
  "e964684f-87fe-49d9-9b87-137cc83165ea"
  ?tbl.Rows(0).Item(1).ToString
  "00390065-0036-0034-3600-380034006600"

[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

2012-03-27T11:36:35

Bugs item #1010500, was opened at 2008-10-28 14:09
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

  Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
  Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
  Dim Tbl As New DataTable
  DA.Fill(zTbl)

When I inspect the values, they differ:

  ?tbl.Rows(0).Item(0).ToString
  "e964684f-87fe-49d9-9b87-137cc83165ea"
  ?tbl.Rows(0).Item(1).ToString
  "00390065-0036-0034-3600-380034006600"

Handling of Arrays broken..?

Barend Köbben — 2012-03-27T08:30:11

Hi,

Since upgrading to PostgreSQL 9.1.2 and its psql-odbc driver (9.0.3.10),
the results of queries to arrays seems broken. I have an SQL 'items'
column of type character(3)[]. A 'normal' SQL query 'SELECT items FROM
table' results in a proper Array (shows in PgAdmin as {100,999,122} ).

In ASP JavaScript the same query done in an ADODB connection...

SQLcmd.CommandText = "SELECT items FROM table";
var RecSet = SQLcmd.Execute;

while (!RecSet.EOF && !RecSet.BOF) {
        var theItemsStr = RecSet.Fields.Item("items").Value;

...results in theItemsStr being '{10'

The same code worked in an earlier installation with Postgres 8.4 and its
driver (version?).


By accident I found that the same thing with the SQL "SELECT items[1:99]
FROM table" does work correctly (even if the array only has 3 items). Is
this a bug that has been introduced in the new version of the driver, or
is there something else I missed...?

Yours,

--
Barend Köbben
ITC - University of Twente,
Faculty of Geo-Information Science and Earth O

[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

2012-03-26T09:02:26

Bugs item #1010500, was opened at 28/10/2008 15:09
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

  Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
  Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
  Dim Tbl As New DataTable
  DA.Fill(zTbl)

When I inspect the values, they differ:

  ?tbl.Rows(0).Item(0).ToString
  "e964684f-87fe-49d9-9b87-137cc83165ea"
  ?tbl.Rows(0).Item(1).ToString
  "00390065-0036-0034-3600-380034006600"

[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

2012-03-24T15:09:08

Bugs item #1010500, was opened at 2008-10-28 14:09
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

  Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
  Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
  Dim Tbl As New DataTable
  DA.Fill(zTbl)

When I inspect the values, they differ:

  ?tbl.Rows(0).Item(0).ToString
  "e964684f-87fe-49d9-9b87-137cc83165ea"
  ?tbl.Rows(0).Item(1).ToString
  "00390065-0036-0034-3600-380034006600"

[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

2012-03-23T13:39:36

Bugs item #1010500, was opened at 28/10/2008 15:09
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

  Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
  Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
  Dim Tbl As New DataTable
  DA.Fill(zTbl)

When I inspect the values, they differ:

  ?tbl.Rows(0).Item(0).ToString
  "e964684f-87fe-49d9-9b87-137cc83165ea"
  ?tbl.Rows(0).Item(1).ToString
  "00390065-0036-0034-3600-380034006600"

[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

2012-03-22T23:48:43

Bugs item #1010500, was opened at 2008-10-28 14:09
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&group_id=1000125

Category: None
Group: None
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

  Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
  Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
  Dim Tbl As New DataTable
  DA.Fill(zTbl)

When I inspect the values, they differ:

  ?tbl.Rows(0).Item(0).ToString
  "e964684f-87fe-49d9-9b87-137cc83165ea"
  ?tbl.Rows(0).Item(1).ToString
  "00390065-0036-0034-3600-380034006600"

The original

[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

2012-03-20T15:26:50

Bugs item #1010500, was opened at 28/10/2008 15:09
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&group_id=1000125

Category: None
Group: None
Status: Closed
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

  Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
  Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
  Dim Tbl As New DataTable
  DA.Fill(zTbl)

When I inspect the values, they differ:

  ?tbl.Rows(0).Item(0).ToString
  "e964684f-87fe-49d9-9b87-137cc83165ea"
  ?tbl.Rows(0).Item(1).ToString
  "00390065-0036-0034-3600-380034006600

[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

2012-03-20T14:10:32

Bugs item #1010500, was opened at 28/10/2008 15:09
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&group_id=1000125

Category: None
Group: None
Status: Closed
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

  Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
  Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
  Dim Tbl As New DataTable
  DA.Fill(zTbl)

When I inspect the values, they differ:

  ?tbl.Rows(0).Item(0).ToString
  "e964684f-87fe-49d9-9b87-137cc83165ea"
  ?tbl.Rows(0).Item(1).ToString
  "00390065-0036-0034-3600-380034006600