"Invalid Pointer Operation" while reading tuples - Mailing list pgsql-general

From claudia.amorim@pcinformatica.com.br
Subject "Invalid Pointer Operation" while reading tuples
Date
Msg-id 51994.200.178.103.132.1196165581.squirrel@smart
Whole thread Raw
List pgsql-general
Hello,

I'm receiving an error message "Invalid pointer operation" when I'm reading data
from my database.
I'm using PostGreSQL 8.2.5 with Windows 2003 Server Enterprise Edition.
When I saw the psqlodbc log I found teh messages below:


[11.281]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=206,
errmsg='Illegal parameter value for SQL_TXN_ISOLATION'


[0.250]STATEMENT ERROR: func=set_statement_option, desc='', errnum=30,
errmsg='The option may be for MS SQL Server(Set)'


Some parts of the log:

[11.281]conn=02FB5D98, query='COMMIT'
[11.281]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=206,
errmsg='Illegal parameter value for SQL_TXN_ISOLATION'
[11.281]            ------------------------------------------------------------
[11.281]            henv=02FB2F58, conn=02FB5D98, status=1, num_stmts=16
[11.281]            sock=02FA3178, stmts=02DEBD38, lobj_type=17288
[11.281]            ---------------- Socket Info -------------------------------
[11.281]            socket=724, reverse=0, errornumber=0, errormsg='(NULL)'
[11.281]            buffer_in=48140048, buffer_out=48153296
[11.281]            buffer_filled_in=18, buffer_filled_out=0, buffer_read_in=18





[0.250]conn=02DE3A70, query='close "SQL_CUR02FA8CA8"'
[0.250]conn=02DE3A70, query='RELEASE _per_query_svp_'
[0.250]conn=02DE3A70, query='close "SQL_CUR02DE85C8"'
[0.250]conn=02DE3A70, query='RELEASE _per_query_svp_'
[0.250]conn=02DE3A70, query='COMMIT'
[0.250]STATEMENT ERROR: func=set_statement_option, desc='', errnum=30,
errmsg='The option may be for MS SQL Server(Set)'
[0.250]
------------------------------------------------------------
[0.250]                 hdbc=02DE3A70, stmt=02DEABE8, result=00000000
[0.250]                 prepare=0, internal=0
[0.250]                 bindings=00000000, bindings_allocated=0
[0.250]                 parameters=00000000, parameters_allocated=0
[0.250]                 statement_type=-2, statement='(NULL)'
[0.250]                 stmt_with_params='(NULL)'
[0.250]                 data_at_exec=-1, current_exec_param=-1, put_data=0
[0.250]                 currTuple=-1, current_col=-1, lobj_fd=-1
[0.250]                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
[0.250]                 cursor_name=''
[0.250]                 ----------------QResult Info
-------------------------------
[0.250]CONN ERROR: func=set_statement_option, desc='', errnum=0, errmsg='(NULL)'



Can you help me?


Thanks,
Cláudia.






pgsql-general by date:

Previous
From: Zoltan Boszormenyi
Date:
Subject: Re: select using an index
Next
From: "Thomas Chille"
Date:
Subject: Re: autovacuum process blocks without reporting a deadlock