CC_connect: entering... CC_connect(): DSN = '', server = '192.168.0.254', port = '5432', database = 'template1', username = 'pgsql', password='' connecting to the server socket... connection to the server socket succeeded. sizeof startup packet = 292 sent the authentication block. sent the authentication block successfully. gonna do authentication read 5, global_socket_buffersize=4096 auth got 'R' areq = 0 read 10, global_socket_buffersize=4096 auth got 'K' auth got 'Z' sending an empty query... send_query(): conn=66011712, query=' ' send_query: done sending query in QR_Constructor exit QR_Constructor read 3, global_socket_buffersize=4096 send_query: got id = 'I' send_query: got id = 'Z' QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR empty query seems to be OK. CC_send_settings: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 66011712, stmt = 67111616 CC_add_statement: self=66011712, stmt=67111616 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=67111616, statement='set DateStyle to 'ISO'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 67111616 PGAPI_Execute: copying statement params: trans_status=1, len=22, stmt='set DateStyle to 'ISO'' stmt_with_params = 'set DateStyle to 'ISO'' it's NOT a select statement: stmt=67111616 send_query(): conn=66011712, query='set DateStyle to 'ISO'' send_query: done sending query in QR_Constructor exit QR_Constructor read 15, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - SET VARIABLE send_query: setting cmdbuffer = 'SET VARIABLE' send_query: returning res = 67111312 send_query: got id = 'Z' PGAPI_ExecDirect: returned 0 from PGAPI_Execute CC_send_settings: result 0, status 1 from set DateStyle PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=67111616, statement='set geqo to 'OFF'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... PGAPI_Execute: recycling statement (should have been done by app)... recycle statement: self= 67111616 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=67111716 recycle statement: self= 67111616 APD_free_params: ENTER, self=67111716 PGAPI_Execute: copying statement params: trans_status=1, len=17, stmt='set geqo to 'OFF'' stmt_with_params = 'set geqo to 'OFF'' it's NOT a select statement: stmt=67111616 send_query(): conn=66011712, query='set geqo to 'OFF'' send_query: done sending query in QR_Constructor exit QR_Constructor read 15, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - SET VARIABLE send_query: setting cmdbuffer = 'SET VARIABLE' send_query: returning res = 67111312 send_query: got id = 'Z' PGAPI_ExecDirect: returned 0 from PGAPI_Execute CC_send_settings: result 0, status 1 from set geqo PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=67111616, statement='set ksqo to 'ON'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... PGAPI_Execute: recycling statement (should have been done by app)... recycle statement: self= 67111616 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=67111716 recycle statement: self= 67111616 APD_free_params: ENTER, self=67111716 PGAPI_Execute: copying statement params: trans_status=1, len=16, stmt='set ksqo to 'ON'' stmt_with_params = 'set ksqo to 'ON'' it's NOT a select statement: stmt=67111616 send_query(): conn=66011712, query='set ksqo to 'ON'' send_query: done sending query in QR_Constructor exit QR_Constructor read 15, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - SET VARIABLE send_query: setting cmdbuffer = 'SET VARIABLE' send_query: returning res = 67111312 send_query: got id = 'Z' PGAPI_ExecDirect: returned 0 from PGAPI_Execute CC_send_settings: result 0, status 1 from set ksqo PGAPI_FreeStmt: entering...hstmt=67111616, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=67111616, self->result=0, self->hdbc=66011712 APD_free_params: ENTER, self=67111716 SC_Destructor: EXIT CC_lookup_lo: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 66011712, stmt = 67111616 CC_add_statement: self=66011712, stmt=67111616 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=67111616, statement='select oid from pg_type where typname='lo'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 67111616 PGAPI_Execute: copying statement params: trans_status=1, len=42, stmt='select oid from pg_type where typname='lo'' stmt_with_params = 'select oid from pg_type where typname='lo'' Sending SELECT statement on stmt=67111616, cursor_name='SQL_CUR04000AC0' send_query(): conn=66011712, query='select oid from pg_type where typname='lo'' send_query: done sending query in QR_Constructor exit QR_Constructor read 33, global_socket_buffersize=4096 send_query: got id = 'P' send_query: got id = 'T' QR_fetch_tuples: cursor = '', self->cursor=0 num_fields = 1 READING ATTTYPMOD CI_read_fields: fieldname='oid', adtid=26, adtsize=4, atttypmod=-1 QR_fetch_tuples: past CI_read_fields: num_fields = 1 MALLOC: tuple_size = 100, size = 800 next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101 end of tuple list -- setting inUse to false: this = 67111248 _next_tuple: 'C': DONE (fcount == 0) send_query: got id = 'Z' done sending the query: extend_column_bindings: entering ... self=67111664, bindings_allocated=0, num_columns=1 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute PGAPI_Fetch: stmt = 67111616, stmt->result= 67111248 manual_result = 0, use_declarefetch = 0 PGAPI_FreeStmt: entering...hstmt=67111616, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=67111616, self->result=0, self->hdbc=66011712 reset_a_column_binding: entering ... self=67111664, bindings_allocated=1, icol=1 APD_free_params: ENTER, self=67111716 SC_Destructor: EXIT CC_lookup_pg_version: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 66011712, stmt = 67111616 CC_add_statement: self=66011712, stmt=67111616 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=67111616, statement='select version()' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 67111616 PGAPI_Execute: copying statement params: trans_status=1, len=16, stmt='select version()' stmt_with_params = 'select version()' Sending SELECT statement on stmt=67111616, cursor_name='SQL_CUR04000AC0' send_query(): conn=66011712, query='select version()' send_query: done sending query in QR_Constructor exit QR_Constructor read 110, global_socket_buffersize=4096 send_query: got id = 'P' send_query: got id = 'T' QR_fetch_tuples: cursor = '', self->cursor=0 num_fields = 1 READING ATTTYPMOD CI_read_fields: fieldname='version', adtid=25, adtsize=-1, atttypmod=-1 QR_fetch_tuples: past CI_read_fields: num_fields = 1 MALLOC: tuple_size = 100, size = 800 next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101 qresult: len=67, buffer='PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' end of tuple list -- setting inUse to false: this = 67111312 _next_tuple: 'C' fetch_max && fcount = 1 send_query: got id = 'Z' done sending the query: extend_column_bindings: entering ... self=67111664, bindings_allocated=0, num_columns=1 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute PGAPI_Fetch: stmt = 67111616, stmt->result= 67111312 manual_result = 0, use_declarefetch = 0 **** SC_fetch: manual_result fetch: cols=1, lf=0, opts = 67111664, opts->bindings = 67110240, buffer[] = 0 PGAPI_GetData: enter, stmt=67111616 num_rows = 1 value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' **** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' copy_and_convert: field_type = 25, fctype = 1, value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3', cbValueMax=128 DEFAULT: len = 67, ptr = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' SQL_C_CHAR, default: len = 67, cbValueMax = 128, rgbValueBindRow = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' Got the PostgreSQL version string: 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' Extracted PostgreSQL version number: '7.2' PGAPI_FreeStmt: entering...hstmt=67111616, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=1 row = 0, num_fields = 1 free [lf=0] 67110304 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=67111616, self->result=0, self->hdbc=66011712 reset_a_column_binding: entering ... self=67111664, bindings_allocated=1, icol=1 APD_free_params: ENTER, self=67111716 SC_Destructor: EXIT CC_lookup_characterset: entering... send_query(): conn=66011712, query='select pg_client_encoding()' send_query: done sending query in QR_Constructor exit QR_Constructor read 60, global_socket_buffersize=4096 send_query: got id = 'P' send_query: got id = 'T' QR_fetch_tuples: cursor = '', self->cursor=0 num_fields = 1 READING ATTTYPMOD CI_read_fields: fieldname='pg_client_encoding', adtid=19, adtsize=32, atttypmod=-1 QR_fetch_tuples: past CI_read_fields: num_fields = 1 MALLOC: tuple_size = 100, size = 800 next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101 qresult: len=6, buffer='LATIN5' end of tuple list -- setting inUse to false: this = 67111808 _next_tuple: 'C' fetch_max && fcount = 1 send_query: got id = 'Z' QResult: in DESTRUCTOR QResult: free memory in, fcount=1 row = 0, num_fields = 1 free [lf=0] 67111664 QResult: free memory out QResult: exit DESTRUCTOR CC_connect: returning... szConnStrOut = 'DRIVER={PostgreSQL};DATABASE=template1;SERVER=192.168.0.254;PORT=5432;UID=pgsql;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0' len=504,1024 PGAPI_DriverConnect: returning 0 [SQLError]**** PGAPI_Error: henv=0, hdbc=66011712 hstmt=0 **** PGAPI_ConnectError: hdbc=66011712 <512> enter CC_get_error enter CC_create_errormsg msg = '' exit CC_create_errormsg exit CC_get_error CC_Get_error returned nothing. **** PGAPI_Error exit code=100 [SQLGetFunctions]PGAPI_GetFunctions: entering...0 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=23 PGAPI_GetInfo: p='', len=2, value=2, cbMax=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=24 PGAPI_GetInfo: p='', len=2, value=2, cbMax=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=79 PGAPI_GetInfo: p='', len=4, value=31, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=83 PGAPI_GetInfo: p='', len=4, value=7, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=78 PGAPI_GetInfo: p='', len=4, value=1, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=81 PGAPI_GetInfo: p='', len=4, value=15, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=72 PGAPI_GetInfo: p='', len=4, value=2, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=82 PGAPI_GetInfo: p='', len=4, value=90, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=44 PGAPI_GetInfo: p='', len=4, value=17, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=43 PGAPI_GetInfo: p='', len=4, value=5, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=79 PGAPI_GetInfo: p='', len=4, value=31, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=8 PGAPI_GetInfo: p='', len=4, value=191, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=80 PGAPI_GetInfo: p='', len=4, value=0, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=78 PGAPI_GetInfo: p='', len=4, value=1, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=79 PGAPI_GetInfo: p='', len=4, value=31, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=8 PGAPI_GetInfo: p='', len=4, value=191, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=80 PGAPI_GetInfo: p='', len=4, value=0, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=78 PGAPI_GetInfo: p='', len=4, value=1, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=79 PGAPI_GetInfo: p='', len=4, value=31, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=8 PGAPI_GetInfo: p='', len=4, value=191, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=80 PGAPI_GetInfo: p='', len=4, value=0, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=78 PGAPI_GetInfo: p='', len=4, value=1, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=8 PGAPI_GetInfo: p='', len=4, value=191, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=80 PGAPI_GetInfo: p='', len=4, value=0, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=111 PGAPI_GetInfo: p='N', len=0, value=0, cbMax=512 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=16 PGAPI_GetInfo: p='', len=0, value=0, cbMax=0 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=23 PGAPI_GetInfo: p='', len=2, value=2, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=24 PGAPI_GetInfo: p='', len=2, value=2, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=46 PGAPI_GetInfo: p='', len=2, value=2, cbMax=4 [SQLSetConnectionOption]PGAPI_SetConnectOption: entering fOption = 1 vParam = 0 SetStmtOption(): SQL_MAX_ROWS, vParam = 0 [SQLSetConnectionOption]PGAPI_SetConnectOption: entering fOption = 0 vParam = 0 SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 0 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=6 PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=52 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=6 PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=52 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=6 PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=52 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=6 PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=48 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=79 PGAPI_GetInfo: p='', len=4, value=31, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=1 PGAPI_GetInfo: p='', len=2, value=0, cbMax=4 [SQLGetConnectOption]PGAPI_GetConnectOption: entering... [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=26 PGAPI_GetInfo: p='', len=4, value=2, cbMax=4 [SQLAllocStmt]PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 66011712, stmt = 67111120 CC_add_statement: self=66011712, stmt=67111120 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=36 PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=4 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CONCURRENCY 1 [SQLGetConnectOption]PGAPI_GetConnectOption: entering... [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 30 [SQLParamOptions]PGAPI_ParamOptions: entering... 1 0 [SQLExecDirect]PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=67111120, statement='SELECT version(), datlastsysoid FROM pg_database WHERE datname = 'template1'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 67111120 PGAPI_Execute: copying statement params: trans_status=1, len=76, stmt='SELECT version(), datlastsysoid FROM pg_database WHERE datname = 'template1'' stmt_with_params = 'SELECT version(), datlastsysoid FROM pg_database WHERE datname = 'template1'' Sending SELECT statement on stmt=67111120, cursor_name='SQL_CUR040008D0' send_query(): conn=66011712, query='SELECT version(), datlastsysoid FROM pg_database WHERE datname = 'template1'' send_query: done sending query in QR_Constructor exit QR_Constructor read 143, global_socket_buffersize=4096 send_query: got id = 'P' send_query: got id = 'T' QR_fetch_tuples: cursor = '', self->cursor=0 num_fields = 2 READING ATTTYPMOD CI_read_fields: fieldname='version', adtid=25, adtsize=-1, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='datlastsysoid', adtid=26, adtsize=4, atttypmod=-1 QR_fetch_tuples: past CI_read_fields: num_fields = 2 MALLOC: tuple_size = 100, size = 1600 next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101 qresult: len=67, buffer='PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' qresult: len=5, buffer='16554' end of tuple list -- setting inUse to false: this = 67111712 _next_tuple: 'C' fetch_max && fcount = 1 send_query: got id = 'Z' done sending the query: extend_column_bindings: entering ... self=67111168, bindings_allocated=0, num_columns=2 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute [SQLRowCount]PGAPI_RowCount: entering... [SQLNumResultCols]PGAPI_NumResultCols: entering... SC_pre_execute: status = 3 PGAPI_NumResultCols: result = 67111712, status = 3, numcols = 2 [SQLNumResultCols]PGAPI_NumResultCols: entering... SC_pre_execute: status = 3 PGAPI_NumResultCols: result = 67111712, status = 3, numcols = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.1.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111712, stmt->status = 3, !finished=0, !premature=1 getCharColumnSize: type=25, col=0, unknown = 0 describeCol: col 0 fieldname = 'version' describeCol: col 0 fieldtype = 25 describeCol: col 0 column_size = 65536 describeCol: col 0 *pfSqlType = -1 describeCol: col 0 *pcbColDef = 65536 describeCol: col 0 *pibScale = 0 describeCol: col 0 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=1 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111712, status = 3, numcols = 2 colAttr: col 0 field_type = 25 PGAPI_ColAttr: COLUMN_NAME = 'version' [SQLColAttributes]PGAPI_ColAttributes: entering..col=1 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111712, status = 3, numcols = 2 colAttr: col 0 field_type = 25 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.2.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111712, stmt->status = 3, !finished=0, !premature=1 describeCol: col 1 fieldname = 'datlastsysoid' describeCol: col 1 fieldtype = 26 describeCol: col 1 column_size = 10 describeCol: col 1 *pfSqlType = 4 describeCol: col 1 *pcbColDef = 10 describeCol: col 1 *pibScale = 0 describeCol: col 1 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111712, status = 3, numcols = 2 colAttr: col 1 field_type = 26 PGAPI_ColAttr: COLUMN_NAME = 'datlastsysoid' [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 8 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111712, status = 3, numcols = 2 colAttr: col 1 field_type = 26 [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111712, status = 3, numcols = 2 colAttr: col 1 field_type = 26 PGAPI_ColAttr: UPDATEABLE = 2 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption(): SQL_RETRIEVE_DATA, vParam = 0 [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption(): SQL_RETRIEVE_DATA, vParam = 1 [SQLFetch]PGAPI_Fetch: stmt = 67111120, stmt->result= 67111712 manual_result = 0, use_declarefetch = 0 **** SC_fetch: manual_result fetch: cols=2, lf=0, opts = 67111168, opts->bindings = 67110912, buffer[] = 0 fetch: cols=2, lf=1, opts = 67111168, opts->bindings = 67110912, buffer[] = 0 [SQLGetData]PGAPI_GetData: enter, stmt=67111120 num_rows = 1 value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' **** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' copy_and_convert: field_type = 25, fctype = 1, value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3', cbValueMax=0 [SQLGetData]PGAPI_GetData: enter, stmt=67111120 num_rows = 1 value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' **** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' copy_and_convert: field_type = 25, fctype = 1, value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3', cbValueMax=0 [SQLGetData]PGAPI_GetData: enter, stmt=67111120 num_rows = 1 value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' **** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' copy_and_convert: field_type = 25, fctype = 1, value = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3', cbValueMax=68 DEFAULT: len = 67, ptr = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' SQL_C_CHAR, default: len = 67, cbValueMax = 68, rgbValueBindRow = 'PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3' [SQLGetData]PGAPI_GetData: enter, stmt=67111120 num_rows = 1 value = '16554' **** PGAPI_GetData: icol = 1, fCType = -18, field_type = 26, value = '16554' copy_and_convert: field_type = 26, fctype = -18, value = '16554', cbValueMax=4 rgb=4100050 + 0, pcb=83e1c0, set 16554 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=2 reset_a_column_binding: entering ... self=67111168, bindings_allocated=2, icol=1 reset_a_column_binding: entering ... self=67111168, bindings_allocated=2, icol=2 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=0 recycle statement: self= 67111120 QResult: in DESTRUCTOR QResult: free memory in, fcount=1 row = 0, num_fields = 2 free [lf=0] 67111008 free [lf=1] 67110992 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=67111220 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=1 SC_Destructor: self=67111120, self->result=0, self->hdbc=66011712 reset_a_column_binding: entering ... self=67111168, bindings_allocated=2, icol=1 reset_a_column_binding: entering ... self=67111168, bindings_allocated=2, icol=2 APD_free_params: ENTER, self=67111220 SC_Destructor: EXIT [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=7 PGAPI_GetInfo: p='07.02.0001', len=0, value=0, cbMax=0 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=7 PGAPI_GetInfo: p='07.02.0001', len=0, value=0, cbMax=22 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=18 PGAPI_GetInfo: p='07.02.0001 PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3', len=0, value=0, cbMax=0 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=18 PGAPI_GetInfo: p='07.02.0001 PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3', len=0, value=0, cbMax=158 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=17 PGAPI_GetInfo: p='PostgreSQL', len=0, value=0, cbMax=0 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=17 PGAPI_GetInfo: p='PostgreSQL', len=0, value=0, cbMax=22 [SQLAllocStmt]PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 66011712, stmt = 67111120 CC_add_statement: self=66011712, stmt=67111120 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=36 PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=4 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CONCURRENCY 1 [SQLGetConnectOption]PGAPI_GetConnectOption: entering... [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 30 [SQLParamOptions]PGAPI_ParamOptions: entering... 1 0 [SQLExecDirect]PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=67111120, statement='SELECT * FROM pg_group ORDER BY groname' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 67111120 PGAPI_Execute: copying statement params: trans_status=1, len=39, stmt='SELECT * FROM pg_group ORDER BY groname' stmt_with_params = 'SELECT * FROM pg_group ORDER BY groname' Sending SELECT statement on stmt=67111120, cursor_name='SQL_CUR040008D0' send_query(): conn=66011712, query='SELECT * FROM pg_group ORDER BY groname' send_query: done sending query in QR_Constructor exit QR_Constructor read 74, global_socket_buffersize=4096 send_query: got id = 'P' send_query: got id = 'T' QR_fetch_tuples: cursor = '', self->cursor=0 num_fields = 3 READING ATTTYPMOD CI_read_fields: fieldname='groname', adtid=19, adtsize=32, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='grosysid', adtid=23, adtsize=4, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='grolist', adtid=1007, adtsize=-1, atttypmod=-1 QR_fetch_tuples: past CI_read_fields: num_fields = 3 MALLOC: tuple_size = 100, size = 2400 next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101 end of tuple list -- setting inUse to false: this = 67111808 _next_tuple: 'C': DONE (fcount == 0) send_query: got id = 'Z' done sending the query: extend_column_bindings: entering ... self=67111168, bindings_allocated=0, num_columns=3 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute [SQLRowCount]PGAPI_RowCount: entering... [SQLNumResultCols]PGAPI_NumResultCols: entering... SC_pre_execute: status = 3 PGAPI_NumResultCols: result = 67111808, status = 3, numcols = 3 [SQLNumResultCols]PGAPI_NumResultCols: entering... SC_pre_execute: status = 3 PGAPI_NumResultCols: result = 67111808, status = 3, numcols = 3 [SQLDescribeCol]PGAPI_DescribeCol: entering.1.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 describeCol: col 0 fieldname = 'groname' describeCol: col 0 fieldtype = 19 describeCol: col 0 column_size = 32 describeCol: col 0 *pfSqlType = 1 describeCol: col 0 *pcbColDef = 32 describeCol: col 0 *pibScale = 0 describeCol: col 0 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=1 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 3 colAttr: col 0 field_type = 19 PGAPI_ColAttr: COLUMN_NAME = 'groname' [SQLColAttributes]PGAPI_ColAttributes: entering..col=1 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 3 colAttr: col 0 field_type = 19 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.2.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 describeCol: col 1 fieldname = 'grosysid' describeCol: col 1 fieldtype = 23 describeCol: col 1 column_size = 10 describeCol: col 1 *pfSqlType = 4 describeCol: col 1 *pcbColDef = 10 describeCol: col 1 *pibScale = 0 describeCol: col 1 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 3 colAttr: col 1 field_type = 23 PGAPI_ColAttr: COLUMN_NAME = 'grosysid' [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 8 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 3 colAttr: col 1 field_type = 23 [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 3 colAttr: col 1 field_type = 23 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.3.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 getCharColumnSize: type=1007, col=2, unknown = 0 describeCol: col 2 fieldname = 'grolist' describeCol: col 2 fieldtype = 1007 describeCol: col 2 column_size = 65536 describeCol: col 2 *pfSqlType = -1 describeCol: col 2 *pcbColDef = 65536 describeCol: col 2 *pibScale = 0 describeCol: col 2 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=3 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 3 colAttr: col 2 field_type = 1007 PGAPI_ColAttr: COLUMN_NAME = 'grolist' [SQLColAttributes]PGAPI_ColAttributes: entering..col=3 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 3 colAttr: col 2 field_type = 1007 PGAPI_ColAttr: UPDATEABLE = 2 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption(): SQL_RETRIEVE_DATA, vParam = 0 [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption(): SQL_RETRIEVE_DATA, vParam = 1 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 1 **** : fCType=1 rgb=4100040 valusMax=33 pcb=4100038 bound buffer[0] = 68157504 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 2 **** : fCType=-16 rgb=4100070 valusMax=4 pcb=4100068 bound buffer[1] = 68157552 [SQLFetch]PGAPI_Fetch: stmt = 67111120, stmt->result= 67111808 manual_result = 0, use_declarefetch = 0 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=2 reset_a_column_binding: entering ... self=67111168, bindings_allocated=3, icol=1 reset_a_column_binding: entering ... self=67111168, bindings_allocated=3, icol=2 reset_a_column_binding: entering ... self=67111168, bindings_allocated=3, icol=3 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=0 recycle statement: self= 67111120 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=67111220 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=1 SC_Destructor: self=67111120, self->result=0, self->hdbc=66011712 reset_a_column_binding: entering ... self=67111168, bindings_allocated=3, icol=1 reset_a_column_binding: entering ... self=67111168, bindings_allocated=3, icol=2 reset_a_column_binding: entering ... self=67111168, bindings_allocated=3, icol=3 APD_free_params: ENTER, self=67111220 SC_Destructor: EXIT [SQLAllocStmt]PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 66011712, stmt = 67111120 CC_add_statement: self=66011712, stmt=67111120 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=36 PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=4 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CONCURRENCY 1 [SQLGetConnectOption]PGAPI_GetConnectOption: entering... [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 30 [SQLParamOptions]PGAPI_ParamOptions: entering... 1 0 [SQLExecDirect]PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=67111120, statement='SELECT * FROM pg_user ORDER BY usename' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 67111120 PGAPI_Execute: copying statement params: trans_status=1, len=38, stmt='SELECT * FROM pg_user ORDER BY usename' stmt_with_params = 'SELECT * FROM pg_user ORDER BY usename' Sending SELECT statement on stmt=67111120, cursor_name='SQL_CUR040008D0' send_query(): conn=66011712, query='SELECT * FROM pg_user ORDER BY usename' send_query: done sending query in QR_Constructor exit QR_Constructor read 271, global_socket_buffersize=4096 send_query: got id = 'P' send_query: got id = 'T' QR_fetch_tuples: cursor = '', self->cursor=0 num_fields = 8 READING ATTTYPMOD CI_read_fields: fieldname='usename', adtid=19, adtsize=32, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='usesysid', adtid=23, adtsize=4, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='usecreatedb', adtid=16, adtsize=1, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='usetrace', adtid=16, adtsize=1, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='usesuper', adtid=16, adtsize=1, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='usecatupd', adtid=16, adtsize=1, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='passwd', adtid=25, adtsize=-1, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='valuntil', adtid=702, adtsize=4, atttypmod=-1 QR_fetch_tuples: past CI_read_fields: num_fields = 8 MALLOC: tuple_size = 100, size = 6400 next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101 qresult: len=6, buffer='ertank' qresult: len=3, buffer='100' qresult: len=1, buffer='f' qresult: len=1, buffer='f' qresult: len=1, buffer='f' qresult: len=1, buffer='f' qresult: len=8, buffer='********' qresult: len=5, buffer='pgsql' qresult: len=1, buffer='1' qresult: len=1, buffer='t' qresult: len=1, buffer='t' qresult: len=1, buffer='t' qresult: len=1, buffer='t' qresult: len=8, buffer='********' end of tuple list -- setting inUse to false: this = 67111808 _next_tuple: 'C' fetch_max && fcount = 2 send_query: got id = 'Z' done sending the query: extend_column_bindings: entering ... self=67111168, bindings_allocated=0, num_columns=8 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute [SQLRowCount]PGAPI_RowCount: entering... [SQLNumResultCols]PGAPI_NumResultCols: entering... SC_pre_execute: status = 3 PGAPI_NumResultCols: result = 67111808, status = 3, numcols = 8 [SQLNumResultCols]PGAPI_NumResultCols: entering... SC_pre_execute: status = 3 PGAPI_NumResultCols: result = 67111808, status = 3, numcols = 8 [SQLDescribeCol]PGAPI_DescribeCol: entering.1.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 describeCol: col 0 fieldname = 'usename' describeCol: col 0 fieldtype = 19 describeCol: col 0 column_size = 32 describeCol: col 0 *pfSqlType = 1 describeCol: col 0 *pcbColDef = 32 describeCol: col 0 *pibScale = 0 describeCol: col 0 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=1 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 0 field_type = 19 PGAPI_ColAttr: COLUMN_NAME = 'usename' [SQLColAttributes]PGAPI_ColAttributes: entering..col=1 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 0 field_type = 19 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.2.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 describeCol: col 1 fieldname = 'usesysid' describeCol: col 1 fieldtype = 23 describeCol: col 1 column_size = 10 describeCol: col 1 *pfSqlType = 4 describeCol: col 1 *pcbColDef = 10 describeCol: col 1 *pibScale = 0 describeCol: col 1 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 1 field_type = 23 PGAPI_ColAttr: COLUMN_NAME = 'usesysid' [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 8 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 1 field_type = 23 [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 1 field_type = 23 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.3.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 describeCol: col 2 fieldname = 'usecreatedb' describeCol: col 2 fieldtype = 16 describeCol: col 2 column_size = 1 describeCol: col 2 *pfSqlType = 1 describeCol: col 2 *pcbColDef = 1 describeCol: col 2 *pibScale = 0 describeCol: col 2 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=3 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 2 field_type = 16 PGAPI_ColAttr: COLUMN_NAME = 'usecreatedb' [SQLColAttributes]PGAPI_ColAttributes: entering..col=3 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 2 field_type = 16 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.4.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 describeCol: col 3 fieldname = 'usetrace' describeCol: col 3 fieldtype = 16 describeCol: col 3 column_size = 1 describeCol: col 3 *pfSqlType = 1 describeCol: col 3 *pcbColDef = 1 describeCol: col 3 *pibScale = 0 describeCol: col 3 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=4 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 3 field_type = 16 PGAPI_ColAttr: COLUMN_NAME = 'usetrace' [SQLColAttributes]PGAPI_ColAttributes: entering..col=4 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 3 field_type = 16 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.5.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 describeCol: col 4 fieldname = 'usesuper' describeCol: col 4 fieldtype = 16 describeCol: col 4 column_size = 1 describeCol: col 4 *pfSqlType = 1 describeCol: col 4 *pcbColDef = 1 describeCol: col 4 *pibScale = 0 describeCol: col 4 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=5 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 4 field_type = 16 PGAPI_ColAttr: COLUMN_NAME = 'usesuper' [SQLColAttributes]PGAPI_ColAttributes: entering..col=5 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 4 field_type = 16 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.6.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 describeCol: col 5 fieldname = 'usecatupd' describeCol: col 5 fieldtype = 16 describeCol: col 5 column_size = 1 describeCol: col 5 *pfSqlType = 1 describeCol: col 5 *pcbColDef = 1 describeCol: col 5 *pibScale = 0 describeCol: col 5 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=6 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 5 field_type = 16 PGAPI_ColAttr: COLUMN_NAME = 'usecatupd' [SQLColAttributes]PGAPI_ColAttributes: entering..col=6 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 5 field_type = 16 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.7.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 getCharColumnSize: type=25, col=6, unknown = 0 describeCol: col 6 fieldname = 'passwd' describeCol: col 6 fieldtype = 25 describeCol: col 6 column_size = 65536 describeCol: col 6 *pfSqlType = -1 describeCol: col 6 *pcbColDef = 65536 describeCol: col 6 *pibScale = 0 describeCol: col 6 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=7 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 6 field_type = 25 PGAPI_ColAttr: COLUMN_NAME = 'passwd' [SQLColAttributes]PGAPI_ColAttributes: entering..col=7 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 6 field_type = 25 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.8.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111808, stmt->status = 3, !finished=0, !premature=1 describeCol: col 7 fieldname = 'valuntil' describeCol: col 7 fieldtype = 702 describeCol: col 7 column_size = 22 describeCol: col 7 *pfSqlType = 11 describeCol: col 7 *pcbColDef = 22 describeCol: col 7 *pibScale = 0 describeCol: col 7 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=8 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 7 field_type = 702 PGAPI_ColAttr: COLUMN_NAME = 'valuntil' [SQLColAttributes]PGAPI_ColAttributes: entering..col=8 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111808, status = 3, numcols = 8 colAttr: col 7 field_type = 702 PGAPI_ColAttr: UPDATEABLE = 2 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption(): SQL_RETRIEVE_DATA, vParam = 0 [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption(): SQL_RETRIEVE_DATA, vParam = 1 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 1 **** : fCType=1 rgb=4100040 valusMax=33 pcb=4100038 bound buffer[0] = 68157504 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 2 **** : fCType=-16 rgb=4100070 valusMax=4 pcb=4100068 bound buffer[1] = 68157552 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 3 **** : fCType=1 rgb=4100080 valusMax=2 pcb=4100078 bound buffer[2] = 68157568 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 4 **** : fCType=1 rgb=4100090 valusMax=2 pcb=4100088 bound buffer[3] = 68157584 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 5 **** : fCType=1 rgb=41000a0 valusMax=2 pcb=4100098 bound buffer[4] = 68157600 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 6 **** : fCType=1 rgb=41000b0 valusMax=2 pcb=41000a8 bound buffer[5] = 68157616 [SQLFetch]PGAPI_Fetch: stmt = 67111120, stmt->result= 67111808 manual_result = 0, use_declarefetch = 0 **** SC_fetch: manual_result fetch: cols=8, lf=0, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157504 type = 19 value = 'ertank' copy_and_convert: field_type = 19, fctype = 1, value = 'ertank', cbValueMax=33 DEFAULT: len = 6, ptr = 'ertank' SQL_C_CHAR, default: len = 6, cbValueMax = 33, rgbValueBindRow = 'ertank' copy_and_convert: retval = 0 fetch: cols=8, lf=1, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157552 type = 23 value = '100' copy_and_convert: field_type = 23, fctype = -16, value = '100', cbValueMax=4 copy_and_convert: retval = 0 fetch: cols=8, lf=2, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157568 type = 16 value = 'f' copy_and_convert: field_type = 16, fctype = 1, value = 'f', cbValueMax=2 PG_TYPE_BOOL: rgbValueBindRow = '0' copy_and_convert: retval = 0 fetch: cols=8, lf=3, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157584 type = 16 value = 'f' copy_and_convert: field_type = 16, fctype = 1, value = 'f', cbValueMax=2 PG_TYPE_BOOL: rgbValueBindRow = '0' copy_and_convert: retval = 0 fetch: cols=8, lf=4, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157600 type = 16 value = 'f' copy_and_convert: field_type = 16, fctype = 1, value = 'f', cbValueMax=2 PG_TYPE_BOOL: rgbValueBindRow = '0' copy_and_convert: retval = 0 fetch: cols=8, lf=5, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157616 type = 16 value = 'f' copy_and_convert: field_type = 16, fctype = 1, value = 'f', cbValueMax=2 PG_TYPE_BOOL: rgbValueBindRow = '0' copy_and_convert: retval = 0 fetch: cols=8, lf=6, opts = 67111168, opts->bindings = 67110320, buffer[] = 0 fetch: cols=8, lf=7, opts = 67111168, opts->bindings = 67110320, buffer[] = 0 [SQLGetData]PGAPI_GetData: enter, stmt=67111120 num_rows = 2 value = '(null)' **** PGAPI_GetData: icol = 7, fCType = 11, field_type = 702, value = '(null)' copy_and_convert: field_type = 702, fctype = 11, value = '', cbValueMax=16 [SQLFetch]PGAPI_Fetch: stmt = 67111120, stmt->result= 67111808 manual_result = 0, use_declarefetch = 0 **** SC_fetch: manual_result fetch: cols=8, lf=0, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157504 type = 19 value = 'pgsql' copy_and_convert: field_type = 19, fctype = 1, value = 'pgsql', cbValueMax=33 DEFAULT: len = 5, ptr = 'pgsql' SQL_C_CHAR, default: len = 5, cbValueMax = 33, rgbValueBindRow = 'pgsql' copy_and_convert: retval = 0 fetch: cols=8, lf=1, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157552 type = 23 value = '1' copy_and_convert: field_type = 23, fctype = -16, value = '1', cbValueMax=4 copy_and_convert: retval = 0 fetch: cols=8, lf=2, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157568 type = 16 value = 't' copy_and_convert: field_type = 16, fctype = 1, value = 't', cbValueMax=2 PG_TYPE_BOOL: rgbValueBindRow = '1' copy_and_convert: retval = 0 fetch: cols=8, lf=3, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157584 type = 16 value = 't' copy_and_convert: field_type = 16, fctype = 1, value = 't', cbValueMax=2 PG_TYPE_BOOL: rgbValueBindRow = '1' copy_and_convert: retval = 0 fetch: cols=8, lf=4, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157600 type = 16 value = 't' copy_and_convert: field_type = 16, fctype = 1, value = 't', cbValueMax=2 PG_TYPE_BOOL: rgbValueBindRow = '1' copy_and_convert: retval = 0 fetch: cols=8, lf=5, opts = 67111168, opts->bindings = 67110320, buffer[] = 68157616 type = 16 value = 't' copy_and_convert: field_type = 16, fctype = 1, value = 't', cbValueMax=2 PG_TYPE_BOOL: rgbValueBindRow = '1' copy_and_convert: retval = 0 fetch: cols=8, lf=6, opts = 67111168, opts->bindings = 67110320, buffer[] = 0 fetch: cols=8, lf=7, opts = 67111168, opts->bindings = 67110320, buffer[] = 0 [SQLGetData]PGAPI_GetData: enter, stmt=67111120 num_rows = 2 value = '(null)' **** PGAPI_GetData: icol = 7, fCType = 11, field_type = 702, value = '(null)' copy_and_convert: field_type = 702, fctype = 11, value = '', cbValueMax=16 [SQLFetch]PGAPI_Fetch: stmt = 67111120, stmt->result= 67111808 manual_result = 0, use_declarefetch = 0 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=2 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=1 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=2 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=3 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=4 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=5 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=6 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=7 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=8 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=0 recycle statement: self= 67111120 QResult: in DESTRUCTOR QResult: free memory in, fcount=2 row = 0, num_fields = 8 free [lf=0] 67110816 free [lf=1] 67110800 free [lf=2] 67110784 free [lf=3] 67110768 free [lf=4] 67110752 free [lf=5] 67110736 free [lf=6] 67110704 row = 1, num_fields = 8 free [lf=0] 67110688 free [lf=1] 67110672 free [lf=2] 67110656 free [lf=3] 67110640 free [lf=4] 67110624 free [lf=5] 67110608 free [lf=6] 67110576 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=67111220 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=1 SC_Destructor: self=67111120, self->result=0, self->hdbc=66011712 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=1 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=2 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=3 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=4 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=5 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=6 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=7 reset_a_column_binding: entering ... self=67111168, bindings_allocated=8, icol=8 APD_free_params: ENTER, self=67111220 SC_Destructor: EXIT [SQLAllocStmt]PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 66011712, stmt = 67111120 CC_add_statement: self=66011712, stmt=67111120 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=36 PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=4 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CONCURRENCY 1 [SQLGetConnectOption]PGAPI_GetConnectOption: entering... [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 30 [SQLParamOptions]PGAPI_ParamOptions: entering... 1 0 [SQLExecDirect]PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=67111120, statement='SELECT oid, *, pg_encoding_to_char(encoding) AS encodingname, pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 67111120 PGAPI_Execute: copying statement params: trans_status=1, len=131, stmt='SELECT oid, *, pg_encoding_to_char(encoding) AS encodingname, pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname' stmt_with_params = 'SELECT oid, *, pg_encoding_to_char(encoding) AS encodingname, pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname' Sending SELECT statement on stmt=67111120, cursor_name='SQL_CUR040008D0' send_query(): conn=66011712, query='SELECT oid, *, pg_encoding_to_char(encoding) AS encodingname, pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname' send_query: done sending query in QR_Constructor exit QR_Constructor read 634, global_socket_buffersize=4096 send_query: got id = 'P' send_query: got id = 'T' QR_fetch_tuples: cursor = '', self->cursor=0 num_fields = 12 READING ATTTYPMOD CI_read_fields: fieldname='oid', adtid=26, adtsize=4, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='datname', adtid=19, adtsize=32, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='datdba', adtid=23, adtsize=4, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='encoding', adtid=23, adtsize=4, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='datistemplate', adtid=16, adtsize=1, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='datallowconn', adtid=16, adtsize=1, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='datlastsysoid', adtid=26, adtsize=4, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='datvacuumxid', adtid=28, adtsize=4, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='datfrozenxid', adtid=28, adtsize=4, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='datpath', adtid=25, adtsize=-1, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='encodingname', adtid=19, adtsize=32, atttypmod=-1 READING ATTTYPMOD CI_read_fields: fieldname='datowner', adtid=19, adtsize=32, atttypmod=-1 QR_fetch_tuples: past CI_read_fields: num_fields = 12 MALLOC: tuple_size = 100, size = 9600 next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101 qresult: len=5, buffer='16556' qresult: len=5, buffer='ertan' qresult: len=1, buffer='1' qresult: len=2, buffer='11' qresult: len=1, buffer='f' qresult: len=1, buffer='t' qresult: len=5, buffer='16554' qresult: len=4, buffer='6734' qresult: len=10, buffer='3221232207' qresult: len=0, buffer='' qresult: len=6, buffer='LATIN5' qresult: len=5, buffer='pgsql' qresult: len=5, buffer='16791' qresult: len=7, buffer='karinca' qresult: len=1, buffer='1' qresult: len=2, buffer='11' qresult: len=1, buffer='f' qresult: len=1, buffer='t' qresult: len=5, buffer='16554' qresult: len=4, buffer='6673' qresult: len=10, buffer='3221232146' qresult: len=0, buffer='' qresult: len=6, buffer='LATIN5' qresult: len=5, buffer='pgsql' qresult: len=5, buffer='16555' qresult: len=9, buffer='template0' qresult: len=1, buffer='1' qresult: len=2, buffer='11' qresult: len=1, buffer='t' qresult: len=1, buffer='f' qresult: len=5, buffer='16554' qresult: len=2, buffer='49' qresult: len=2, buffer='49' qresult: len=0, buffer='' qresult: len=6, buffer='LATIN5' qresult: len=5, buffer='pgsql' qresult: len=1, buffer='1' qresult: len=9, buffer='template1' qresult: len=1, buffer='1' qresult: len=2, buffer='11' qresult: len=1, buffer='t' qresult: len=1, buffer='t' qresult: len=5, buffer='16554' qresult: len=2, buffer='49' qresult: len=2, buffer='49' qresult: len=0, buffer='' qresult: len=6, buffer='LATIN5' qresult: len=5, buffer='pgsql' end of tuple list -- setting inUse to false: this = 67111664 _next_tuple: 'C' fetch_max && fcount = 4 send_query: got id = 'Z' done sending the query: extend_column_bindings: entering ... self=67111168, bindings_allocated=0, num_columns=12 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute [SQLRowCount]PGAPI_RowCount: entering... [SQLNumResultCols]PGAPI_NumResultCols: entering... SC_pre_execute: status = 3 PGAPI_NumResultCols: result = 67111664, status = 3, numcols = 12 [SQLNumResultCols]PGAPI_NumResultCols: entering... SC_pre_execute: status = 3 PGAPI_NumResultCols: result = 67111664, status = 3, numcols = 12 [SQLDescribeCol]PGAPI_DescribeCol: entering.1.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 0 fieldname = 'oid' describeCol: col 0 fieldtype = 26 describeCol: col 0 column_size = 10 describeCol: col 0 *pfSqlType = 4 describeCol: col 0 *pcbColDef = 10 describeCol: col 0 *pibScale = 0 describeCol: col 0 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=1 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 0 field_type = 26 PGAPI_ColAttr: COLUMN_NAME = 'oid' [SQLColAttributes]PGAPI_ColAttributes: entering..col=1 8 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 0 field_type = 26 [SQLColAttributes]PGAPI_ColAttributes: entering..col=1 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 0 field_type = 26 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.2.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 1 fieldname = 'datname' describeCol: col 1 fieldtype = 19 describeCol: col 1 column_size = 32 describeCol: col 1 *pfSqlType = 1 describeCol: col 1 *pcbColDef = 32 describeCol: col 1 *pibScale = 0 describeCol: col 1 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 1 field_type = 19 PGAPI_ColAttr: COLUMN_NAME = 'datname' [SQLColAttributes]PGAPI_ColAttributes: entering..col=2 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 1 field_type = 19 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.3.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 2 fieldname = 'datdba' describeCol: col 2 fieldtype = 23 describeCol: col 2 column_size = 10 describeCol: col 2 *pfSqlType = 4 describeCol: col 2 *pcbColDef = 10 describeCol: col 2 *pibScale = 0 describeCol: col 2 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=3 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 2 field_type = 23 PGAPI_ColAttr: COLUMN_NAME = 'datdba' [SQLColAttributes]PGAPI_ColAttributes: entering..col=3 8 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 2 field_type = 23 [SQLColAttributes]PGAPI_ColAttributes: entering..col=3 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 2 field_type = 23 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.4.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 3 fieldname = 'encoding' describeCol: col 3 fieldtype = 23 describeCol: col 3 column_size = 10 describeCol: col 3 *pfSqlType = 4 describeCol: col 3 *pcbColDef = 10 describeCol: col 3 *pibScale = 0 describeCol: col 3 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=4 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 3 field_type = 23 PGAPI_ColAttr: COLUMN_NAME = 'encoding' [SQLColAttributes]PGAPI_ColAttributes: entering..col=4 8 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 3 field_type = 23 [SQLColAttributes]PGAPI_ColAttributes: entering..col=4 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 3 field_type = 23 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.5.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 4 fieldname = 'datistemplate' describeCol: col 4 fieldtype = 16 describeCol: col 4 column_size = 1 describeCol: col 4 *pfSqlType = 1 describeCol: col 4 *pcbColDef = 1 describeCol: col 4 *pibScale = 0 describeCol: col 4 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=5 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 4 field_type = 16 PGAPI_ColAttr: COLUMN_NAME = 'datistemplate' [SQLColAttributes]PGAPI_ColAttributes: entering..col=5 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 4 field_type = 16 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.6.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 5 fieldname = 'datallowconn' describeCol: col 5 fieldtype = 16 describeCol: col 5 column_size = 1 describeCol: col 5 *pfSqlType = 1 describeCol: col 5 *pcbColDef = 1 describeCol: col 5 *pibScale = 0 describeCol: col 5 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=6 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 5 field_type = 16 PGAPI_ColAttr: COLUMN_NAME = 'datallowconn' [SQLColAttributes]PGAPI_ColAttributes: entering..col=6 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 5 field_type = 16 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.7.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 6 fieldname = 'datlastsysoid' describeCol: col 6 fieldtype = 26 describeCol: col 6 column_size = 10 describeCol: col 6 *pfSqlType = 4 describeCol: col 6 *pcbColDef = 10 describeCol: col 6 *pibScale = 0 describeCol: col 6 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=7 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 6 field_type = 26 PGAPI_ColAttr: COLUMN_NAME = 'datlastsysoid' [SQLColAttributes]PGAPI_ColAttributes: entering..col=7 8 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 6 field_type = 26 [SQLColAttributes]PGAPI_ColAttributes: entering..col=7 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 6 field_type = 26 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.8.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 7 fieldname = 'datvacuumxid' describeCol: col 7 fieldtype = 28 describeCol: col 7 column_size = 10 describeCol: col 7 *pfSqlType = 4 describeCol: col 7 *pcbColDef = 10 describeCol: col 7 *pibScale = 0 describeCol: col 7 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=8 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 7 field_type = 28 PGAPI_ColAttr: COLUMN_NAME = 'datvacuumxid' [SQLColAttributes]PGAPI_ColAttributes: entering..col=8 8 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 7 field_type = 28 [SQLColAttributes]PGAPI_ColAttributes: entering..col=8 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 7 field_type = 28 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.9.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 8 fieldname = 'datfrozenxid' describeCol: col 8 fieldtype = 28 describeCol: col 8 column_size = 10 describeCol: col 8 *pfSqlType = 4 describeCol: col 8 *pcbColDef = 10 describeCol: col 8 *pibScale = 0 describeCol: col 8 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=9 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 8 field_type = 28 PGAPI_ColAttr: COLUMN_NAME = 'datfrozenxid' [SQLColAttributes]PGAPI_ColAttributes: entering..col=9 8 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 8 field_type = 28 [SQLColAttributes]PGAPI_ColAttributes: entering..col=9 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 8 field_type = 28 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.10.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 getCharColumnSize: type=25, col=9, unknown = 0 describeCol: col 9 fieldname = 'datpath' describeCol: col 9 fieldtype = 25 describeCol: col 9 column_size = 65536 describeCol: col 9 *pfSqlType = -1 describeCol: col 9 *pcbColDef = 65536 describeCol: col 9 *pibScale = 0 describeCol: col 9 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=10 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 9 field_type = 25 PGAPI_ColAttr: COLUMN_NAME = 'datpath' [SQLColAttributes]PGAPI_ColAttributes: entering..col=10 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 9 field_type = 25 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.11.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 10 fieldname = 'encodingname' describeCol: col 10 fieldtype = 19 describeCol: col 10 column_size = 32 describeCol: col 10 *pfSqlType = 1 describeCol: col 10 *pcbColDef = 32 describeCol: col 10 *pibScale = 0 describeCol: col 10 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=11 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 10 field_type = 19 PGAPI_ColAttr: COLUMN_NAME = 'encodingname' [SQLColAttributes]PGAPI_ColAttributes: entering..col=11 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 10 field_type = 19 PGAPI_ColAttr: UPDATEABLE = 2 [SQLDescribeCol]PGAPI_DescribeCol: entering.12.. SC_pre_execute: status = 3 **** PGAPI_DescribeCol: res = 67111664, stmt->status = 3, !finished=0, !premature=1 describeCol: col 11 fieldname = 'datowner' describeCol: col 11 fieldtype = 19 describeCol: col 11 column_size = 32 describeCol: col 11 *pfSqlType = 1 describeCol: col 11 *pcbColDef = 32 describeCol: col 11 *pibScale = 0 describeCol: col 11 *pfNullable = 1 [SQLColAttributes]PGAPI_ColAttributes: entering..col=12 18 len=512. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 11 field_type = 19 PGAPI_ColAttr: COLUMN_NAME = 'datowner' [SQLColAttributes]PGAPI_ColAttributes: entering..col=12 10 len=0. SC_pre_execute: status = 3 **** PGAPI_ColAtt: result = 67111664, status = 3, numcols = 12 colAttr: col 11 field_type = 19 PGAPI_ColAttr: UPDATEABLE = 2 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLGetStmtOption]PGAPI_GetStmtOption: entering... GetStmtOption(): SQL_CURSOR_TYPE 0 [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption(): SQL_RETRIEVE_DATA, vParam = 0 [SQLSetStmtOption]PGAPI_SetStmtOption: entering... SetStmtOption(): SQL_RETRIEVE_DATA, vParam = 1 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 1 **** : fCType=-18 rgb=4100040 valusMax=4 pcb=4100038 bound buffer[0] = 68157504 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 2 **** : fCType=1 rgb=4100050 valusMax=33 pcb=4100048 bound buffer[1] = 68157520 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 3 **** : fCType=-16 rgb=4100080 valusMax=4 pcb=4100078 bound buffer[2] = 68157568 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 4 **** : fCType=-16 rgb=4100090 valusMax=4 pcb=4100088 bound buffer[3] = 68157584 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 5 **** : fCType=1 rgb=41000a0 valusMax=2 pcb=4100098 bound buffer[4] = 68157600 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 6 **** : fCType=1 rgb=41000b0 valusMax=2 pcb=41000a8 bound buffer[5] = 68157616 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 7 **** : fCType=-18 rgb=41000c0 valusMax=4 pcb=41000b8 bound buffer[6] = 68157632 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 8 **** : fCType=-18 rgb=41000d0 valusMax=4 pcb=41000c8 bound buffer[7] = 68157648 [SQLBindCol]PGAPI_BindCol: entering... **** PGAPI_BindCol: stmt = 67111120, icol = 9 **** : fCType=-18 rgb=41000e0 valusMax=4 pcb=41000d8 bound buffer[8] = 68157664 [SQLFetch]PGAPI_Fetch: stmt = 67111120, stmt->result= 67111664 manual_result = 0, use_declarefetch = 0 **** SC_fetch: manual_result fetch: cols=12, lf=0, opts = 67111168, opts->bindings = 67109392, buffer[] = 68157504 type = 26 value = '16556' copy_and_convert: field_type = 26, fctype = -18, value = '16556', cbValueMax=4 rgb=4100040 + 0, pcb=4100038, set 16556 copy_and_convert: retval = 0 fetch: cols=12, lf=1, opts = 67111168, opts->bindings = 67109392, buffer[] = 68157520 type = 19 value = 'ertan' copy_and_convert: field_type = 19, fctype = 1, value = 'ertan', cbValueMax=33 DEFAULT: len = 5, ptr = 'ertan' SQL_C_CHAR, default: len = 5, cbValueMax = 33, rgbValueBindRow = 'ertan' copy_and_convert: retval = 0 fetch: cols=12, lf=2, opts = 67111168, opts->bindings = 67109392, buffer[] = 68157568 type = 23 value = '1' copy_and_convert: field_type = 23, fctype = -16, value = '1', cbValueMax=4 copy_and_convert: retval = 0 fetch: cols=12, lf=3, opts = 67111168, opts->bindings = 67109392, buffer[] = 68157584 type = 23 value = '11' copy_and_convert: field_type = 23, fctype = -16, value = '11', cbValueMax=4 copy_and_convert: retval = 0 fetch: cols=12, lf=4, opts = 67111168, opts->bindings = 67109392, buffer[] = 68157600 type = 16 value = 'f' copy_and_convert: field_type = 16, fctype = 1, value = 'f', cbValueMax=2 PG_TYPE_BOOL: rgbValueBindRow = '0' copy_and_convert: retval = 0 fetch: cols=12, lf=5, opts = 67111168, opts->bindings = 67109392, buffer[] = 68157616 type = 16 value = 't' copy_and_convert: field_type = 16, fctype = 1, value = 't', cbValueMax=2 PG_TYPE_BOOL: rgbValueBindRow = '1' copy_and_convert: retval = 0 fetch: cols=12, lf=6, opts = 67111168, opts->bindings = 67109392, buffer[] = 68157632 type = 26 value = '16554' copy_and_convert: field_type = 26, fctype = -18, value = '16554', cbValueMax=4 rgb=41000c0 + 0, pcb=41000b8, set 16554 copy_and_convert: retval = 0 fetch: cols=12, lf=7, opts = 67111168, opts->bindings = 67109392, buffer[] = 68157648 type = 28 value = '6734' copy_and_convert: field_type = 28, fctype = -18, value = '6734', cbValueMax=4 rgb=41000d0 + 0, pcb=41000c8, set 6734 copy_and_convert: retval = 0 fetch: cols=12, lf=8, opts = 67111168, opts->bindings = 67109392, buffer[] = 68157664 type = 28 value = '3221232207' copy_and_convert: field_type = 28, fctype = -18, value = '3221232207', cbValueMax=4 rgb=41000e0 + 0, pcb=41000d8, set 3221232207 copy_and_convert: retval = 0 fetch: cols=12, lf=9, opts = 67111168, opts->bindings = 67109392, buffer[] = 0 fetch: cols=12, lf=10, opts = 67111168, opts->bindings = 67109392, buffer[] = 0 fetch: cols=12, lf=11, opts = 67111168, opts->bindings = 67109392, buffer[] = 0 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=2 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=1 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=2 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=3 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=4 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=5 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=6 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=7 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=8 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=9 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=10 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=11 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=12 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=0 recycle statement: self= 67111120 QResult: in DESTRUCTOR QResult: free memory in, fcount=4 row = 0, num_fields = 12 free [lf=0] 67110576 free [lf=1] 67110560 free [lf=2] 67110544 free [lf=3] 67110528 free [lf=4] 67110512 free [lf=5] 67110496 free [lf=6] 67110480 free [lf=7] 67110464 free [lf=8] 67110432 free [lf=9] 67110416 free [lf=10] 67110400 free [lf=11] 67110384 row = 1, num_fields = 12 free [lf=0] 67110368 free [lf=1] 67110352 free [lf=2] 67110336 free [lf=3] 67110320 free [lf=4] 67110304 free [lf=5] 67110288 free [lf=6] 67110272 free [lf=7] 67110256 free [lf=8] 67110224 free [lf=9] 67110208 free [lf=10] 67110192 free [lf=11] 67110176 row = 2, num_fields = 12 free [lf=0] 67110160 free [lf=1] 67110128 free [lf=2] 67110112 free [lf=3] 67110096 free [lf=4] 67110080 free [lf=5] 67110064 free [lf=6] 67110048 free [lf=7] 67110032 free [lf=8] 67110016 free [lf=9] 67110000 free [lf=10] 67109984 free [lf=11] 67109968 row = 3, num_fields = 12 free [lf=0] 67109952 free [lf=1] 67109920 free [lf=2] 67109904 free [lf=3] 67109888 free [lf=4] 67109872 free [lf=5] 67109856 free [lf=6] 67109840 free [lf=7] 67109824 free [lf=8] 67109808 free [lf=9] 67109792 free [lf=10] 67109776 free [lf=11] 67109760 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=67111220 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=67111120, fOption=1 SC_Destructor: self=67111120, self->result=0, self->hdbc=66011712 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=1 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=2 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=3 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=4 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=5 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=6 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=7 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=8 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=9 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=10 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=11 reset_a_column_binding: entering ... self=67111168, bindings_allocated=12, icol=12 APD_free_params: ENTER, self=67111220 SC_Destructor: EXIT [SQLDisconnect]PGAPI_Disconnect: entering...