| From: | claudia(dot)amorim(at)pcinformatica(dot)com(dot)br | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | "Invalid Pointer Operation" while reading tuples | 
| Date: | 2007-11-27 12:13:01 | 
| Message-ID: | 51994.200.178.103.132.1196165581.squirrel@smart | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas 'ads' Scherbaum | 2007-11-27 13:27:34 | Re: POLL: Women-sized t-shirts for PostgreSQL | 
| Previous Message | Zoltan Boszormenyi | 2007-11-27 11:31:38 | Re: select using an index |