Thread: Bug in libpq version

Bug in libpq version

From
Johann Zuschlag
Date:
Hi Dave,

even though I would like to test the new driver, I can't connect with my
software to the database. The log snippets below state that there is no
database. If I switch to the old driver (08.00.0102) everything works.

regards

Johann

mylog:

[1776]inside if loop got no result from the empty query.  (probably
database does not exist)
[1776]send_query: done sending query
[1776]QR_fetch_tuples: cursor = '', self->cursor=0
[1776]QR_fetch_tuples: past CI_read_fields: num_fields = 0

psqlodbc:

STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while
executing the query'

------------------------------------------------------------
                 hdbc=33961320, stmt=33973256, result=33978024
                 manual_result=1, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=0, statement='select oid from pg_type
where typname='lo''
                 stmt_with_params='declare SQL_CUR02066408 cursor for
select oid from pg_type where typname='lo''
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
                 cursor_name='SQL_CUR02066408'
                 ----------------QResult Info
-------------------------------
                 fields=33978160, manual_tuples=0, backend_tuples=0,
tupleField=0, conn=33961320
                 fetch_count=101, num_total_rows=0, num_fields=0,
cursor='(NULL)'
                 message='(NULL)', command='(NULL)', notice='(NULL)'
                 status=7, inTuples=1
CONN ERROR: func=SC_execute, desc='', errnum=105, errmsg='The database
does not exist on the server'
            ------------------------------------------------------------
            henv=33961264, conn=33961320, status=0, num_stmts=16
conn=33961320, query='select pg_client_encoding()'



Re: Bug in libpq version

From
"Dave Page"
Date:

> -----Original Message-----
> From: Johann Zuschlag [mailto:zuschlag2@online.de]
> Sent: 02 August 2005 20:27
> To: pgsql-odbc@postgresql.org; Dave Page
> Subject: Bug in libpq version
>
> Hi Dave,
>
> even though I would like to test the new driver, I can't
> connect with my
> software to the database. The log snippets below state that
> there is no
> database. If I switch to the old driver (08.00.0102) everything works.

Johann,

> CONN ERROR: func=SC_execute, desc='', errnum=105, errmsg='The database

> does not exist on the server'

That was a generic error message that was in the initial libpq version.
I've fixed it now to retrieve the real message from the backend - please
try the new release which I hope to build in the next day or so.

Regards, Dave.

Re: Bug in libpq version - solved

From
Johann Zuschlag
Date:
>That was a generic error message that was in the initial libpq version.
>I've fixed it now to retrieve the real message from the backend - please
>try the new release which I hope to build in the next day or so.
>
>
>
Dave,

the new driver solved the problem.

Thanks.

Regards

Johann