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

I think I missed something.
Are you trying to call a stored procedure with strongly typed paramters?

I mean like with
param = new Parameter("EmployeeID",adTypeChar,5,"10019")
cmd.Parameters.Add param
cmd.Execute

Has anyone made the parameterized stored procedures work?
I've only made work stored procedures (PostgreSQL user-defined functions), using a constructed string like
sql = "select my_function_name('Brad',26,'M')".
cnn.Execute sql

Is there a parameterized statement, without a stored procedure/user defined function, that can just act
against a table, like "INSERT INTO mytable (fld1, file2) VALUES (?, ?)"


Adam Biser wrote:
> 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,
compiledby GCC 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
to2' 
> [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
>
>
>
> ------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings