Re: Parameters.Refresh error. - Mailing list pgsql-odbc

Ludek Finstrle wrote:

>Please could you send here full mylog output (turn on in Global and
>DataSource dialogs). It helps us to find the problematic place.
>
Attached you will find the mylog output as well as the comm output (if
that will help).

Thanks,
Adam
Global Options: Version='08.01.0102', fetch=100, socket=0, unknown_sizes=254, max_varchar_size=8190,
max_longvarchar_size=0
                disable_optimizer=0, ksqo=0, unique_index=1, use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OTHER'
conn=88422504, query='select version()'
    [ PostgreSQL version string = 'PostgreSQL 8.1.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)'] 
    [ PostgreSQL version number = '8.1' ]
conn=88422504, query='set DateStyle to 'ISO''
conn=88422504, query='set extra_float_digits to 2'
conn=88422504, query='select oid from pg_type where typname='lo''
conn=88422504, query='select pg_client_encoding()'
conn=88422504, query='set client_encoding to 'latin9''
conn=88422504, PGAPI_DriverConnect(out)='DSN=GALSTA
Postgres;DATABASE=GALSTA;SERVER=localhost;PORT=5432;SSLMODE=disable;UID=ADAM;PWD=xxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=8192;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=0;Ksqo=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=1;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=1;LowerCaseIdentifier=0'
DESCRIPTOR ERROR: func=PGAPI_SetDescField, desc='', errnum=11, errmsg='bad parameter number'
conn=88422504, PGAPI_Disconnect

[1936][[SQLAllocHandle]]
[1936]**** in PGAPI_AllocEnv **
[1936]** exit PGAPI_AllocEnv: phenv = 88422448 **
[1936][[SQLSetEnvAttr]] att=200,2
[1936][[SQLAllocHandle]]
[1936]PGAPI_AllocConnect: entering...
[1936]**** PGAPI_AllocConnect: henv = 88422448, conn = 88422504
[1936]EN_add_connection: self = 88422448, conn = 88422504
[1936]       added at i =0, conn->henv = 88422448, conns[i]->henv = 88422448
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=77
[1936]PGAPI_GetInfo: p='03.00', len=5, value=0, cbMax=12
[1936][[SQLSetConnectAttr]] 103
[1936]PGAPI_SetConnectAttr 103
[1936]PGAPI_SetConnectOption: entering fOption = 103 vParam = 15
[1936][SQLDriverConnect]
[1936]PGAPI_DriverConnect: entering...
[1936]**** PGAPI_DriverConnect: fDriverCompletion=0, connStrIn='DSN=GALSTA Postgres;UID=ADAM;PWD=xxxxxx;'
[1936]our_connect_string = 'DSN=GALSTA Postgres;UID=ADAM;PWD=xxxxxx;'
[1936]attribute = 'DSN', value = 'GALSTA Postgres'
[1936]copyAttributes: DSN='GALSTA
Postgres',server='',dbase='',user='',passwd='xxxxx',port='',sslmode='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[1936]attribute = 'UID', value = 'ADAM'
[1936]copyAttributes: DSN='GALSTA
Postgres',server='',dbase='',user='ADAM',passwd='xxxxx',port='',sslmode='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[1936]attribute = 'PWD', value = 'xxxxx'
[1936]copyAttributes: DSN='GALSTA
Postgres',server='',dbase='',user='ADAM',passwd='xxxxx',port='',sslmode='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[1936]globals.extra_systable_prefixes = 'dd_;'
[1936]globals.extra_systable_prefixes = 'dd_;'
[1936]our_connect_string = 'DSN=GALSTA Postgres;UID=ADAM;PWD=xxxxxx;'
[1936]attribute = 'DSN', value = 'GALSTA Postgres'
[1936]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=0;B5=0;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[1936]attribute= 'UID',
value= 'ADAM' 
[1936]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=0;B5=0;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[1936]attribute= 'PWD',
value= 'xxxxx' 
[1936]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=0;B5=0;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[1936]CC_connect:
entering...
[1936]CC_connect(): DSN = 'GALSTA Postgres', server = 'localhost', port = '5432', sslmode = 'disable', database =
'GALSTA',username = 'ADAM', password='xxxxx' 
[1936]connecting to the server
[1936]connecting to the database  using localhost as the server
[1936]the size is 15
[1936]connection to the database succeeded.
[1936]connection to the database succeeded.
[1936]CC_lookup_pg_version: entering...
[1936]PGAPI_AllocStmt: entering...
[1936]**** PGAPI_AllocStmt: hdbc = 88422504, stmt = 88434208
[1936]CC_add_statement: self=88422504, stmt=88434208
[1936]PGAPI_ExecDirect: entering...
[1936]recycle statement: self= 88434208
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]**** PGAPI_ExecDirect: hstmt=88434208, statement='select version()'
[1936]PGAPI_ExecDirect: calling PGAPI_Execute...
[1936]PGAPI_Execute: entering...
[1936]PGAPI_Execute: clear errors...
[1936]recycle statement: self= 88434208
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=16, stmt='select version()'
[1936]   stmt_with_params = 'select version()'
[1936]       Sending SELECT statement on stmt=88434208, cursor_name='SQL_CUR05456620'
[1936]send_query(): conn=88422504, query='select version()'
[1936]in QR_Constructor
[1936]exit QR_Constructor
[1936]in TL_Constructor
[1936]exit TL_Constructor
[1936]send_query: done sending query
[1936]QR_fetch_tuples: cursor = '', self->cursor=0
[1936]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[1936]MALLOC: tuple_size = 100, size = 800
[1936]     done sending the query:
[1936]extend_column_bindings: entering ... self=88434344, bindings_allocated=0, num_columns=1
[1936]exit extend_column_bindings
[1936]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1936]PGAPI_Fetch: stmt = 88434208, stmt->result= 88438976
[1936]manual_result = 1, use_declarefetch = 0
[1936]**** SC_fetch: manual_result
[1936]extend_getdata_info: entering ... self=88434564, gdata_allocated=0, num_columns=1
[1936]exit extend_gdata_info
[1936]fetch: cols=1, lf=0, opts = 88434344, opts->bindings = 88444616, buffer[] = 0
[1936]PGAPI_GetData: enter, stmt=88434208
[1936]     value = 'PostgreSQL 8.1.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)'
[1936]**** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value = 'PostgreSQL 8.1.1 on i686-pc-mingw32, compiled
byGCC gcc.exe (GCC) 3.4.2 (mingw-special)' 
[1936]copy_and_convert: field_type = 25, fctype = 1, value = 'PostgreSQL 8.1.1 on i686-pc-mingw32, compiled by GCC
gcc.exe(GCC) 3.4.2 (mingw-special)', cbValueMax=128 
[1936]DEFAULT: len = 88, ptr = 'PostgreSQL 8.1.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)'
[1936]    SQL_C_CHAR, default: len = 88, cbValueMax = 128, rgbValueBindRow = 'PostgreSQL 8.1.1 on i686-pc-mingw32,
compiledby GCC gcc.exe (GCC) 3.4.2 (mingw-special)' 
[1936]Got the PostgreSQL version string: 'PostgreSQL 8.1.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)'
[1936]Extracted PostgreSQL version number: '8.1'
[1936]PGAPI_FreeStmt: entering...hstmt=88434208, fOption=1
[1936]QResult: in DESTRUCTOR
[1936]TupleList: in DESTRUCTOR
[1936]TupleList: exit DESTRUCTOR
[1936]QResult: free memory in, fcount=101
[1936]QResult: free memory out
[1936]QResult: exit DESTRUCTOR
[1936]SC_Destructor: self=88434208, self->result=0, self->hdbc=88422504
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]ARDFields_free 54566a8 bookmark=5457a28[1936]ARD_unbind_cols freeall=1 allocated=1 bindings=5458ec8
[1936]reset_a_column_binding: entering ... self=88434344, bindings_allocated=1, icol=1
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]GDATA_unbind_cols freeall=1 allocated=1 gdata=5458ef0
[1936]SC_Destructor: EXIT
[1936]CC_send_settings: entering...
[1936]PGAPI_AllocStmt: entering...
[1936]**** PGAPI_AllocStmt: hdbc = 88422504, stmt = 88434208
[1936]CC_add_statement: self=88422504, stmt=88434208
[1936]PGAPI_ExecDirect: entering...
[1936]recycle statement: self= 88434208
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]**** PGAPI_ExecDirect: hstmt=88434208, statement='set DateStyle to 'ISO''
[1936]PGAPI_ExecDirect: calling PGAPI_Execute...
[1936]PGAPI_Execute: entering...
[1936]PGAPI_Execute: clear errors...
[1936]recycle statement: self= 88434208
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=22, stmt='set DateStyle to 'ISO''
[1936]   stmt_with_params = 'set DateStyle to 'ISO''
[1936]      it's NOT a select statement: stmt=88434208
[1936]send_query(): conn=88422504, query='set DateStyle to 'ISO''
[1936]in QR_Constructor
[1936]exit QR_Constructor
[1936]The query was executed successfully and the query did not return any result
[1936]send_query: done sending query
[1936]QR_fetch_tuples: cursor = '', self->cursor=0
[1936]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1936]MALLOC: tuple_size = 100, size = 0
[1936]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1936]CC_send_settings: result 0, status 1 from set DateStyle
[1936]PGAPI_ExecDirect: entering...
[1936]recycle statement: self= 88434208
[1936]QResult: in DESTRUCTOR
[1936]QResult: free memory in, fcount=101
[1936]QResult: free memory out
[1936]QResult: exit DESTRUCTOR
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]**** PGAPI_ExecDirect: hstmt=88434208, statement='set extra_float_digits to 2'
[1936]PGAPI_ExecDirect: calling PGAPI_Execute...
[1936]PGAPI_Execute: entering...
[1936]PGAPI_Execute: clear errors...
[1936]recycle statement: self= 88434208
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=27, stmt='set extra_float_digits to
2'
[1936]   stmt_with_params = 'set extra_float_digits to 2'
[1936]      it's NOT a select statement: stmt=88434208
[1936]send_query(): conn=88422504, query='set extra_float_digits to 2'
[1936]in QR_Constructor
[1936]exit QR_Constructor
[1936]The query was executed successfully and the query did not return any result
[1936]send_query: done sending query
[1936]QR_fetch_tuples: cursor = '', self->cursor=0
[1936]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1936]MALLOC: tuple_size = 100, size = 0
[1936]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1936]CC_send_settings: result 0, status 1 from set extra_float_digits
[1936]PGAPI_FreeStmt: entering...hstmt=88434208, fOption=1
[1936]QResult: in DESTRUCTOR
[1936]QResult: free memory in, fcount=101
[1936]QResult: free memory out
[1936]QResult: exit DESTRUCTOR
[1936]SC_Destructor: self=88434208, self->result=0, self->hdbc=88422504
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]ARDFields_free 54566a8 bookmark=5458ea0[1936]ARD_unbind_cols freeall=1 allocated=0 bindings=0
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]GDATA_unbind_cols freeall=1 allocated=0 gdata=0
[1936]SC_Destructor: EXIT
[1936]CC_lookup_lo: entering...
[1936]PGAPI_AllocStmt: entering...
[1936]**** PGAPI_AllocStmt: hdbc = 88422504, stmt = 88434208
[1936]CC_add_statement: self=88422504, stmt=88434208
[1936]PGAPI_ExecDirect: entering...
[1936]recycle statement: self= 88434208
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]**** PGAPI_ExecDirect: hstmt=88434208, statement='select oid from pg_type where typname='lo''
[1936]PGAPI_ExecDirect: calling PGAPI_Execute...
[1936]PGAPI_Execute: entering...
[1936]PGAPI_Execute: clear errors...
[1936]recycle statement: self= 88434208
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=42, stmt='select oid from pg_type
wheretypname='lo'' 
[1936]   stmt_with_params = 'select oid from pg_type where typname='lo''
[1936]       Sending SELECT statement on stmt=88434208, cursor_name='SQL_CUR05456620'
[1936]send_query(): conn=88422504, query='select oid from pg_type where typname='lo''
[1936]in QR_Constructor
[1936]exit QR_Constructor
[1936]in TL_Constructor
[1936]exit TL_Constructor
[1936]send_query: done sending query
[1936]QR_fetch_tuples: cursor = '', self->cursor=0
[1936]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[1936]MALLOC: tuple_size = 100, size = 800
[1936]     done sending the query:
[1936]extend_column_bindings: entering ... self=88434344, bindings_allocated=0, num_columns=1
[1936]exit extend_column_bindings
[1936]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1936]PGAPI_Fetch: stmt = 88434208, stmt->result= 88438976
[1936]manual_result = 1, use_declarefetch = 0
[1936]PGAPI_FreeStmt: entering...hstmt=88434208, fOption=1
[1936]QResult: in DESTRUCTOR
[1936]TupleList: in DESTRUCTOR
[1936]TupleList: exit DESTRUCTOR
[1936]QResult: free memory in, fcount=101
[1936]QResult: free memory out
[1936]QResult: exit DESTRUCTOR
[1936]SC_Destructor: self=88434208, self->result=0, self->hdbc=88422504
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]ARDFields_free 54566a8 bookmark=5458ea0[1936]ARD_unbind_cols freeall=1 allocated=1 bindings=5458e78
[1936]reset_a_column_binding: entering ... self=88434344, bindings_allocated=1, icol=1
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]GDATA_unbind_cols freeall=1 allocated=0 gdata=0
[1936]SC_Destructor: EXIT
[1936]CC_lookup_characterset: entering...
[1936]send_query(): conn=88422504, query='select pg_client_encoding()'
[1936]in QR_Constructor
[1936]exit QR_Constructor
[1936]in TL_Constructor
[1936]exit TL_Constructor
[1936]send_query: done sending query
[1936]QR_fetch_tuples: cursor = '', self->cursor=0
[1936]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[1936]MALLOC: tuple_size = 100, size = 800
[1936]QResult: in DESTRUCTOR
[1936]TupleList: in DESTRUCTOR
[1936]TupleList: exit DESTRUCTOR
[1936]QResult: free memory in, fcount=101
[1936]QResult: free memory out
[1936]QResult: exit DESTRUCTOR
[1936]send_query(): conn=88422504, query='set client_encoding to 'latin9''
[1936]in QR_Constructor
[1936]exit QR_Constructor
[1936]The query was executed successfully and the query did not return any result
[1936]send_query: done sending query
[1936]QR_fetch_tuples: cursor = '', self->cursor=0
[1936]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1936]MALLOC: tuple_size = 100, size = 0
[1936]QResult: in DESTRUCTOR
[1936]QResult: free memory in, fcount=101
[1936]QResult: free memory out
[1936]QResult: exit DESTRUCTOR
[1936]CC_connect: returning...
[1936]szConnStrOut = 'DSN=GALSTA
Postgres;DATABASE=GALSTA;SERVER=localhost;PORT=5432;SSLMODE=disable;UID=ADAM;PWD=xxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=8192;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=0;Ksqo=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=1;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=1;LowerCaseIdentifier=0'
len=591,1024
[1936]PGAPI_DriverConnect: returning 0
[1936][[SQLGetDiagRec]]
[1936]PGAPI_GetDiagRec entering rec=1
[1936]**** PGAPI_ConnectError: hdbc=88422504 <0>
[1936]enter CC_get_error
[1936]enter CC_create_errormsg
[1936]msg = ''
[1936]exit CC_create_errormsg
[1936]exit CC_get_error
[1936]CC_Get_error returned nothing.
[1936]PGAPI_GetDiagRec exiting 100
[1936][SQLGetFunctions]
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=23
[1936]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=24
[1936]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=79
[1936]PGAPI_GetInfo: p='<NULL>', len=4, value=3, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=83
[1936]PGAPI_GetInfo: p='<NULL>', len=4, value=0, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=78
[1936]PGAPI_GetInfo: p='<NULL>', len=4, value=1, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=81
[1936]PGAPI_GetInfo: p='<NULL>', len=4, value=15, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=72
[1936]PGAPI_GetInfo: p='<NULL>', len=4, value=10, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=82
[1936]PGAPI_GetInfo: p='<NULL>', len=4, value=90, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=44
[1936]PGAPI_GetInfo: p='<NULL>', len=4, value=17, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=43
[1936]PGAPI_GetInfo: p='<NULL>', len=4, value=1, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=144
[1936]PGAPI_GetInfo30: p='<NULL>', len=4, value=0, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=150
[1936]PGAPI_GetInfo30: p='<NULL>', len=4, value=4687, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=167
[1936]PGAPI_GetInfo30: p='<NULL>', len=4, value=4687, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=146
[1936]PGAPI_GetInfo30: p='<NULL>', len=4, value=1, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=151
[1936]PGAPI_GetInfo30: p='<NULL>', len=4, value=1, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=168
[1936]PGAPI_GetInfo30: p='<NULL>', len=4, value=1, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=111
[1936]PGAPI_GetInfo: p='N', len=1, value=0, cbMax=512
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=16
[1936]PGAPI_GetInfo: p='', len=0, value=0, cbMax=0
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=23
[1936]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=24
[1936]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=46
[1936]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[1936][[SQLSetConnectAttr]] 1
[1936]PGAPI_SetConnectAttr 1
[1936]PGAPI_SetConnectOption: entering fOption = 1 vParam = 0
[1936]SetStmtOption(): SQL_MAX_ROWS, vParam = 0
[1936][[SQLSetConnectAttr]] 0
[1936]PGAPI_SetConnectAttr 0
[1936]PGAPI_SetConnectOption: entering fOption = 0 vParam = 0
[1936]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 0
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=6
[1936]PGAPI_GetInfo: p='PSQLODBCA.DLL', len=13, value=0, cbMax=52
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=6
[1936]PGAPI_GetInfo: p='PSQLODBCA.DLL', len=13, value=0, cbMax=52
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=6
[1936]PGAPI_GetInfo: p='PSQLODBCA.DLL', len=13, value=0, cbMax=52
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=6
[1936]PGAPI_GetInfo: p='PSQLODBCA.DLL', len=13, value=0, cbMax=48
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=1
[1936]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[1936][[SQLGetConnectAttr]] 109
[1936]PGAPI_GetConnectAttr 109
[1936]PGAPI_GetConnectOption: entering...
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=26
[1936]PGAPI_GetInfo: p='<NULL>', len=4, value=2, cbMax=4
[1936][[SQLAllocHandle]]
[1936]PGAPI_AllocStmt: entering...
[1936]**** PGAPI_AllocStmt: hdbc = 88422504, stmt = 88434208
[1936]CC_add_statement: self=88422504, stmt=88434208
[1936][[SQLGetStmtAttr]] Handle=88434208 10010
[1936]PGAPI_GetStmtAttr Handle=88434208 10010
[1936][[SQLGetStmtAttr]] Handle=88434208 10011
[1936]PGAPI_GetStmtAttr Handle=88434208 10011
[1936][[SQLGetStmtAttr]] Handle=88434208 10012
[1936]PGAPI_GetStmtAttr Handle=88434208 10012
[1936][[SQLGetStmtAttr]] Handle=88434208 10013
[1936]PGAPI_GetStmtAttr Handle=88434208 10013
[1936][[SQLSetStmtAttr]] Handle=88434208 18,10
[1936]PGAPI_SetStmtAttr Handle=88434208 18,10
[1936][[SQLSetStmtAttr]] Handle=88434208 18,0
[1936]PGAPI_SetStmtAttr Handle=88434208 18,0
[1936][[SQLSetStmtAttr]] Handle=88434208 17,1307176
[1936]PGAPI_SetStmtAttr Handle=88434208 17,1307176
[1936][[SQLSetStmtAttr]] Handle=88434208 17,0
[1936]PGAPI_SetStmtAttr Handle=88434208 17,0
[1936][[SQLSetDescField]] h=88434428 rec=1 field=1004 val=13f228
[1936]PGAPI_SetDescField h=88434428 rec=1 field=1004 val=13f228,0
[1936]DESCRIPTOR ERROR: func=PGAPI_SetDescField, desc='', errnum=11, errmsg='bad parameter number'
[1936][[SQLFreeHandle]]
[1936]PGAPI_FreeStmt: entering...hstmt=88434208, fOption=1
[1936]SC_Destructor: self=88434208, self->result=0, self->hdbc=88422504
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]ARDFields_free 54566a8 bookmark=5458e78[1936]ARD_unbind_cols freeall=1 allocated=0 bindings=0
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]GDATA_unbind_cols freeall=1 allocated=0 gdata=0
[1936]SC_Destructor: EXIT
[1936][[SQLAllocHandle]]
[1936]PGAPI_AllocStmt: entering...
[1936]**** PGAPI_AllocStmt: hdbc = 88422504, stmt = 88434208
[1936]CC_add_statement: self=88422504, stmt=88434208
[1936][[SQLGetStmtAttr]] Handle=88434208 10010
[1936]PGAPI_GetStmtAttr Handle=88434208 10010
[1936][[SQLGetStmtAttr]] Handle=88434208 10011
[1936]PGAPI_GetStmtAttr Handle=88434208 10011
[1936][[SQLGetStmtAttr]] Handle=88434208 10012
[1936]PGAPI_GetStmtAttr Handle=88434208 10012
[1936][[SQLGetStmtAttr]] Handle=88434208 10013
[1936]PGAPI_GetStmtAttr Handle=88434208 10013
[1936][[SQLSetStmtAttr]] Handle=88434208 0,30
[1936]PGAPI_SetStmtAttr Handle=88434208 0,30
[1936]PGAPI_SetStmtOption: entering...
[1936]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 30
[1936][SQLFreeStmt]
[1936]PGAPI_FreeStmt: entering...hstmt=88434208, fOption=3
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]PDATA_free_params:  ENTER, self=88434640
[1936][SQLPrepare]
[1936]PGAPI_Prepare: entering...
[1936]**** PGAPI_Prepare: STMT_ALLOCATED, copy
[1936][SQLGetInfo(30)]
[1936]PGAPI_GetInfo: entering...fInfoType=36
[1936]PGAPI_GetInfo: p='Y', len=1, value=0, cbMax=4
[1936][SQLFreeStmt]
[1936]PGAPI_FreeStmt: entering...hstmt=88434208, fOption=3
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]PDATA_free_params:  ENTER, self=88434640
[1936][SQLPrepare]
[1936]PGAPI_Prepare: entering...
[1936]**** PGAPI_Prepare: STMT_READY, change SQL
[1936][[SQLGetStmtAttr]] Handle=88434208 6
[1936]PGAPI_GetStmtAttr Handle=88434208 6
[1936]PGAPI_GetStmtOption: entering...
[1936]GetStmtOption(): SQL_CURSOR_TYPE 0
[1936][[SQLGetStmtAttr]] Handle=88434208 7
[1936]PGAPI_GetStmtAttr Handle=88434208 7
[1936]PGAPI_GetStmtOption: entering...
[1936]GetStmtOption(): SQL_CONCURRENCY 1
[1936][[SQLGetConnectAttr]] 108
[1936]PGAPI_GetConnectAttr 108
[1936]PGAPI_GetConnectOption: entering...
[1936][SQLNumParams]
[1936]PGAPI_NumParams: entering...
[1936][SQLFreeStmt]
[1936]PGAPI_FreeStmt: entering...hstmt=88434208, fOption=0
[1936]recycle statement: self= 88434208
[1936]PDATA_free_params:  ENTER, self=88434640
[1936][[SQLFreeHandle]]
[1936]PGAPI_FreeStmt: entering...hstmt=88434208, fOption=1
[1936]SC_Destructor: self=88434208, self->result=0, self->hdbc=88422504
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]PDATA_free_params:  ENTER, self=88434640
[1936]ARDFields_free 54566a8 bookmark=5458ea0
[1936]ARD_unbind_cols freeall=1 allocated=0 bindings=0
[1936]APD_free_params:  ENTER, self=88434460
[1936]IPD_free_params:  ENTER, self=88434524
[1936]GDATA_unbind_cols freeall=1 allocated=0 gdata=0
[1936]SC_Destructor: EXIT
[1936][SQLDisconnect]
[1936]PGAPI_Disconnect: entering...
[1936]PGAPI_Disconnect: about to CC_cleanup
[1936]in CC_Cleanup, self=88422504
[1936]after CC_abort
[1936]entering PGCONN_Destructor
[1936]exiting PGCONN_Destructor
[1936]after LIBPQ destructor
[1936]exit CC_Cleanup
[1936]PGAPI_Disconnect: done CC_cleanup
[1936]PGAPI_Disconnect: returning...
[1936][[SQLFreeHandle]]
[1936]PGAPI_FreeConnect: entering...
[1936]**** in PGAPI_FreeConnect: hdbc=88422504
[1936]enter CC_Destructor, self=88422504
[1936]in CC_Cleanup, self=88422504
[1936]after LIBPQ destructor
[1936]exit CC_Cleanup
[1936]after CC_Cleanup
[1936]after free statement holders
[1936]exit CC_Destructor
[1936]PGAPI_FreeConnect: returning...
[1936][[SQLFreeHandle]]
[1936]**** in PGAPI_FreeEnv: env = 88422448 **
[1936]in EN_Destructor, self=88422448
[1936]exit EN_Destructor: rv = 1
[1936]   ok