[2755657728]calling getDSNdefaults [2755657728]CC_connect: entering... [2755657728]sslmode=disable [2755657728]LIBPQ_CC_connect: entering... [2755657728]Driver Version='09.05.0100,Feb 10 2016' [2755657728]LIBPQ_CC_connect: DSN = 'PostgreDSN', server = '127.0.0.1', port = '5432', database = 'postgres', username = 'postgres', password='xxxxx' [2755657728]connecting to the database using 127.0.0.1 as the server [2755657728]libpq connection to the database established. [2755657728]protocol=3 [2755657728]Server version=9.4.1 [2755657728]LIBPQ_connect: retuning 1 [2755657728]CC_setenv: entering... [2755657728]PGAPI_AllocStmt: entering... [2755657728]**** PGAPI_AllocStmt: hdbc = 0x5041c00, stmt = 0x511d600 [2755657728]CC_add_statement: self=0x5041c00, stmt=0x511d600 [2755657728]PGAPI_ExecDirect: entering...0 [2755657728]SC_recycle_statement: self= 0x511d600 [2755657728]**** PGAPI_ExecDirect: hstmt=0x511d600, statement='set DateStyle to 'ISO'' [2755657728]PGAPI_ExecDirect: calling PGAPI_Execute... [2755657728]PGAPI_Execute: entering...0 [2755657728]PGAPI_Execute: clear errors... [2755657728]PGAPI_NumParams: entering... [2755657728]SC_scanQueryAndCountParams: entering... [2755657728]prepareParameters was not called, prepare state:8 [2755657728]SC_recycle_statement: self= 0x511d600 [2755657728]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=22, stmt='set DateStyle to 'ISO'' [2755657728] stmt_with_params = 'set DateStyle to 'ISO'' [2755657728]about to begin SC_execute [2755657728] it's NOT a select statement: stmt=0x511d600 [2755657728]CC_send_query: conn=0x5041c00, query='set DateStyle to 'ISO'' [2755657728]in QR_Constructor [2755657728]exit QR_Constructor [2755657728]send_query: ok - 'C' - SET [2755657728]send_query: setting cmdbuffer = 'SET' [2755657728]send_query: returning res = 0x23b4d970 [2755657728]SC_set_Result(511d600, 23b4d970)[2755657728]QResult: enter DESTRUCTOR [2755657728]retval=0 [2755657728]PGAPI_ExecDirect: returned 0 from PGAPI_Execute [2755657728]CC_setenv: result 0, status 1 from set DateStyle [2755657728]PGAPI_ExecDirect: entering...0 [2755657728]SC_recycle_statement: self= 0x511d600 [2755657728]SC_set_Result(511d600, 0)[2755657728]QResult: enter DESTRUCTOR [2755657728]QResult: in QR_close_result [2755657728]QResult: free memory in, fcount=0 [2755657728]QResult: free memory out [2755657728]QResult: exit close_result [2755657728]QResult: exit DESTRUCTOR [2755657728]PDATA_free_params: ENTER, self=0x511d7c4 [2755657728]**** PGAPI_ExecDirect: hstmt=0x511d600, statement='set extra_float_digits to 2' [2755657728]PGAPI_ExecDirect: calling PGAPI_Execute... [2755657728]PGAPI_Execute: entering...0 [2755657728]PGAPI_Execute: clear errors... [2755657728]PGAPI_NumParams: entering... [2755657728]SC_scanQueryAndCountParams: entering... [2755657728]prepareParameters was not called, prepare state:8 [2755657728]SC_recycle_statement: self= 0x511d600 [2755657728]PDATA_free_params: ENTER, self=0x511d7c4 [2755657728]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=27, stmt='set extra_float_digits to 2' [2755657728] stmt_with_params = 'set extra_float_digits to 2' [2755657728]about to begin SC_execute [2755657728] it's NOT a select statement: stmt=0x511d600 [2755657728]CC_send_query: conn=0x5041c00, query='set extra_float_digits to 2' [2755657728]in QR_Constructor [2755657728]exit QR_Constructor [2755657728]send_query: ok - 'C' - SET [2755657728]send_query: setting cmdbuffer = 'SET' [2755657728]send_query: returning res = 0xc2d4270 [2755657728]SC_set_Result(511d600, c2d4270)[2755657728]QResult: enter DESTRUCTOR [2755657728]retval=0 [2755657728]PGAPI_ExecDirect: returned 0 from PGAPI_Execute [2755657728]CC_setenv: result 0, status 1 from set extra_float_digits [2755657728]PGAPI_FreeStmt: entering...hstmt=0x511d600, fOption=1 [2755657728]QResult: enter DESTRUCTOR [2755657728]QResult: in QR_close_result [2755657728]QResult: free memory in, fcount=0 [2755657728]QResult: free memory out [2755657728]QResult: exit close_result [2755657728]QResult: exit DESTRUCTOR [2755657728]SC_init_Result(511d600)[2755657728]SC_Destructor: self=0x511d600, self->result=0x0, self->hdbc=0x5041c00 [2755657728]APD_free_params: ENTER, self=0x511d708 [2755657728]IPD_free_params: ENTER, self=0x511d748 [2755657728]PDATA_free_params: ENTER, self=0x511d7c4 [2755657728]SC_Destructor: EXIT [2755657728]CC_send_settings: entering... [2755657728]PGAPI_AllocStmt: entering... [2755657728]**** PGAPI_AllocStmt: hdbc = 0x5041c00, stmt = 0x6970200 [2755657728]CC_add_statement: self=0x5041c00, stmt=0x6970200 [2755657728]PGAPI_FreeStmt: entering...hstmt=0x6970200, fOption=1 [2755657728]QResult: enter DESTRUCTOR [2755657728]SC_init_Result(6970200)[2755657728]SC_Destructor: self=0x6970200, self->result=0x0, self->hdbc=0x5041c00 [2755657728]APD_free_params: ENTER, self=0x6970308 [2755657728]IPD_free_params: ENTER, self=0x6970348 [2755657728]PDATA_free_params: ENTER, self=0x69703c4 [2755657728]SC_Destructor: EXIT [2755657728]CC_lookup_lo: entering... [2755657728]CC_send_query: conn=0x5041c00, query='select oid, typbasetype from pg_type where typname = 'lo'' [2755657728]in QR_Constructor [2755657728]exit QR_Constructor [2755657728]num_fields = 2 [2755657728]in QR_set_num_fields [2755657728]exit QR_set_num_fields [2755657728]QR_from_PGResult: fieldname='oid', adtid=26, adtsize=4, atttypmod=-1 (rel,att)=(1247,-2) [2755657728]QR_from_PGResult: fieldname='typbasetype', adtid=26, adtsize=4, atttypmod=-1 (rel,att)=(1247,24) [2755657728]QResult: enter DESTRUCTOR [2755657728]QResult: in QR_close_result [2755657728]QResult: free memory in, fcount=0 [2755657728]QResult: free memory out [2755657728]QResult: exit close_result [2755657728]QResult: exit DESTRUCTOR [2755657728]Got the large object oid: -999 [2755657728]CC_lookup_characterset: entering... [2755657728]conn->unicode=1 [2755657728]CC_connect: returning...1 [2755657728]szConnStrOut = 'DSN=PostgreDSN;DATABASE=postgres;SERVER=127.0.0.1;PORT=5432;UID=postgres;PWD=sa;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=1;CommLog=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=dd_;LFConversion=0;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=1;LowerCaseIdentifier=0;' len=518,4096 [2755657728]PGAPI_DriverConnect: returning 0 [2755657728][SQLGetInfoW][2755657728]PGAPI_GetInfo: entering...fInfoType=23 [2755657728]PGAPI_GetInfo: p='', len=2, value=2, cbMax=2 [2755657728][SQLGetInfoW][2755657728]PGAPI_GetInfo: entering...fInfoType=24 [2755657728]PGAPI_GetInfo: p='', len=2, value=2, cbMax=2 [2755657728][SQLGetInfoW][2755657728]PGAPI_GetInfo: entering...fInfoType=25 [2755657728]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=2044 [2755657728][SQLGetInfoW][2755657728]PGAPI_GetInfo: entering...fInfoType=77 [2755657728]PGAPI_GetInfo: p='03.51', len=0, value=0, cbMax=2044 [2755657728][SQLSetConnectAttrW][2755657728]PGAPI_SetConnectAttr for 0x5041c00: 102 0x1 [2755657728]PGAPI_SetConnectOption: entering fOption = 102 vParam = 1 [2755657728][SQLGetInfoW][2755657728]PGAPI_GetInfo: entering...fInfoType=84 [2755657728]PGAPI_GetInfo: p='', len=2, value=0, cbMax=2 [2755657728][SQLGetInfoW][2755657728]PGAPI_GetInfo: entering...fInfoType=84 [2755657728]PGAPI_GetInfo: p='', len=2, value=0, cbMax=2 [2755657728][SQLGetInfoW][2755657728]PGAPI_GetInfo: entering...fInfoType=77 [2755657728]PGAPI_GetInfo: p='03.51', len=0, value=0, cbMax=2044 [2755657728][SQLGetInfoW][2755657728]PGAPI_GetInfo: entering...fInfoType=93 [2755657728]PGAPI_GetInfo: p='', len=2, value=3, cbMax=2 [2755657728][SQLGetInfoW][2755657728]PGAPI_GetInfo: entering...fInfoType=1 [2755657728]PGAPI_GetInfo: p='', len=2, value=0, cbMax=2 [2755657728][[SQLAllocHandle]][2755657728]PGAPI_AllocStmt: entering... [2755657728]**** PGAPI_AllocStmt: hdbc = 0x5041c00, stmt = 0x6995800 [2755657728]CC_add_statement: self=0x5041c00, stmt=0x6995800 [2755657728][SQLGetStmtAttrW][2755657728]PGAPI_GetStmtAttr Handle=0x6995800 10010 [2755657728][SQLGetStmtAttrW][2755657728]PGAPI_GetStmtAttr Handle=0x6995800 10011 [2755657728][SQLGetStmtAttrW][2755657728]PGAPI_GetStmtAttr Handle=0x6995800 10012 [2755657728][SQLGetStmtAttrW][2755657728]PGAPI_GetStmtAttr Handle=0x6995800 10013 [2755657728][SQLTablesW][2755657728]PGAPI_Tables: entering...stmt=0x6995800 scnm=0x0 len=-1 [2755657728]SC_recycle_statement: self= 0x6995800 [2755657728]PGAPI_AllocStmt: entering... [2755657728]**** PGAPI_AllocStmt: hdbc = 0x5041c00, stmt = 0x6995000 [2755657728]CC_add_statement: self=0x5041c00, stmt=0x6995000 [2755657728]PGAPI_ExecDirect: entering...0 [2755657728]SC_recycle_statement: self= 0x6995000 [2755657728]**** PGAPI_ExecDirect: hstmt=0x6995000, statement='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [2755657728]PGAPI_ExecDirect: calling PGAPI_Execute... [2755657728]PGAPI_Execute: entering...0 [2755657728]PGAPI_Execute: clear errors... [2755657728]PGAPI_NumParams: entering... [2755657728]SC_scanQueryAndCountParams: entering... [2755657728]prepareParameters was not called, prepare state:8 [2755657728]SC_recycle_statement: self= 0x6995000 [2755657728]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=246, stmt='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [2755657728] stmt_with_params = 'select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [2755657728]about to begin SC_execute [2755657728] Sending SELECT statement on stmt=0x6995000, cursor_name='SQL_CUR0x6995000' qflag=0,1 [2755657728]CC_send_query: conn=0x5041c00, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [2755657728]in QR_Constructor [2755657728]exit QR_Constructor [2755657728]num_fields = 3 [2755657728]in QR_set_num_fields [2755657728]exit QR_set_num_fields [2755657728]QR_from_PGResult: fieldname='relname', adtid=19, adtsize=64, atttypmod=-1 (rel,att)=(1259,1) [2755657728]QR_from_PGResult: fieldname='nspname', adtid=19, adtsize=64, atttypmod=-1 (rel,att)=(2615,1) [2755657728]QR_from_PGResult: fieldname='relkind', adtid=18, adtsize=1, atttypmod=-1 (rel,att)=(1259,16) [2755657728]REALLOC: old_count = 0, size = 0 [2755657728]qresult: len=10, buffer='test_table' [2755657728]qresult: len=6, buffer='public' [2755657728]qresult: len=1, buffer='r' [2755657728] done sending the query: [2755657728]extend_column_bindings: entering ... self=0x6995088, bindings_allocated=0, num_columns=3 [2755657728]exit extend_column_bindings=0x23b777f0 [2755657728]SC_set_Result(6995000, 23b776a0)[2755657728]QResult: enter DESTRUCTOR [2755657728]retval=0 [2755657728]PGAPI_ExecDirect: returned 0 from PGAPI_Execute [2755657728]PGAPI_BindCol: entering... [2755657728]**** PGAPI_BindCol: stmt = 0x6995000, icol = 1 [2755657728]**** : fCType=-9999 rgb=0xbfffc0b8 valusMax=128 pcb=0xbfffbda0 [2755657728]extend_getdata_info: entering ... self=0x699517c, gdata_allocated=0, num_columns=1 [2755657728]exit extend_gdata_info=0x23b4df50 [2755657728] bound buffer[0] = 0xbfffc0b8 [2755657728]PGAPI_BindCol: entering... [2755657728]**** PGAPI_BindCol: stmt = 0x6995000, icol = 2 [2755657728]**** : fCType=-9999 rgb=0xbfffc038 valusMax=128 pcb=0xbfffbd98 [2755657728]extend_getdata_info: entering ... self=0x699517c, gdata_allocated=1, num_columns=2 [2755657728]exit extend_gdata_info=0x23b4df60 [2755657728] bound buffer[1] = 0xbfffc038 [2755657728]PGAPI_BindCol: entering... [2755657728]**** PGAPI_BindCol: stmt = 0x6995000, icol = 3 [2755657728]**** : fCType=-9999 rgb=0xbfffbfb8 valusMax=128 pcb=0xbfffbd9c [2755657728]extend_getdata_info: entering ... self=0x699517c, gdata_allocated=2, num_columns=3 [2755657728]exit extend_gdata_info=0x23b77840 [2755657728] bound buffer[2] = 0xbfffbfb8 [2755657728]in QR_Constructor [2755657728]exit QR_Constructor [2755657728]SC_set_Result(6995800, 23b77470)[2755657728]QResult: enter DESTRUCTOR [2755657728]extend_column_bindings: entering ... self=0x6995888, bindings_allocated=0, num_columns=5 [2755657728]exit extend_column_bindings=0x23b77520 [2755657728]in QR_set_num_fields [2755657728]exit QR_set_num_fields [2755657728]PGAPI_Fetch: stmt = 0x6995000, stmt->result= 0x23b776a0 [2755657728]fetch_cursor=0, 0x23b776a0->total_read=1 [2755657728]**** SC_fetch: non-cursor_result [2755657728]fetch: cols=3, lf=0, opts = 0x6995088, opts->bindings = 0x23b777f0, buffer[] = 0xbfffc0b8 [2755657728]type = 19, atttypmod = -1 [2755657728]value = 'test_table' [2755657728]copy_and_convert: field_type = 19, fctype = -9999, value = 'test_table', cbValueMax=128 [2755657728]DEFAULT: len = 10, ptr = 'test_table' [2755657728] SQL_C_CHAR, default: len = 10, cbValueMax = 128, rgbValueBindRow = 'test_table' [2755657728]copy_and_convert: retval = 0 [2755657728]fetch: cols=3, lf=1, opts = 0x6995088, opts->bindings = 0x23b777f0, buffer[] = 0xbfffc038 [2755657728]type = 19, atttypmod = -1 [2755657728]value = 'public' [2755657728]copy_and_convert: field_type = 19, fctype = -9999, value = 'public', cbValueMax=128 [2755657728]DEFAULT: len = 6, ptr = 'public' [2755657728] SQL_C_CHAR, default: len = 6, cbValueMax = 128, rgbValueBindRow = 'public' [2755657728]copy_and_convert: retval = 0 [2755657728]fetch: cols=3, lf=2, opts = 0x6995088, opts->bindings = 0x23b777f0, buffer[] = 0xbfffbfb8 [2755657728]type = 18, atttypmod = -1 [2755657728]value = 'r' [2755657728]copy_and_convert: field_type = 18, fctype = -9999, value = 'r', cbValueMax=128 [2755657728]DEFAULT: len = 1, ptr = 'r' [2755657728] SQL_C_CHAR, default: len = 1, cbValueMax = 128, rgbValueBindRow = 'r' [2755657728]copy_and_convert: retval = 0 [2755657728]table_name='test_table', prefix[0]='dd_' [2755657728]PGAPI_Tables: table_name = 'test_table' [2755657728]PGAPI_Fetch: stmt = 0x6995000, stmt->result= 0x23b776a0 [2755657728]fetch_cursor=0, 0x23b776a0->total_read=1 [2755657728]PGAPI_FreeStmt: entering...hstmt=0x6995000, fOption=1 [2755657728]QResult: enter DESTRUCTOR [2755657728]QResult: in QR_close_result [2755657728]QResult: free memory in, fcount=1 [2755657728]QResult: free memory out [2755657728]QResult: exit close_result [2755657728]QResult: exit DESTRUCTOR [2755657728]SC_init_Result(6995000)[2755657728]SC_Destructor: self=0x6995000, self->result=0x0, self->hdbc=0x5041c00 [2755657728]reset_a_column_binding: entering ... self=0x6995088, bindings_allocated=3, icol=1 [2755657728]reset_a_column_binding: entering ... self=0x6995088, bindings_allocated=3, icol=2 [2755657728]reset_a_column_binding: entering ... self=0x6995088, bindings_allocated=3, icol=3 [2755657728]APD_free_params: ENTER, self=0x6995108 [2755657728]IPD_free_params: ENTER, self=0x6995148 [2755657728]PDATA_free_params: ENTER, self=0x69951c4 [2755657728]SC_Destructor: EXIT [2755657728]PGAPI_Tables: EXIT, stmt=0x6995800, ret=0 [2755657728][SQLNumResultCols][2755657728]PGAPI_NumResultCols: entering... [2755657728]SC_describe: status = 3 [2755657728]PGAPI_NumResultCols: result = 0x23b77470, status = 3, numcols = 5 [2755657728][[SQLFetch]][2755657728]PGAPI_ExtendedFetch: stmt=0x6995800 rowsetSize=1 [2755657728]SQL_FETCH_NEXT: num_tuples=1, currtuple=-1, rowst=-1 [2755657728]PGAPI_ExtendedFetch: new currTuple = -1 [2755657728]fetch_cursor=0, 0x23b77470->total_read=0 [2755657728]**** SC_fetch: non-cursor_result [2755657728]extend_getdata_info: entering ... self=0x699597c, gdata_allocated=0, num_columns=5 [2755657728]exit extend_gdata_info=0xc2d7eb0 [2755657728]fetch: cols=5, lf=0, opts = 0x6995888, opts->bindings = 0x23b77520, buffer[] = 0x0 [2755657728]fetch: cols=5, lf=1, opts = 0x6995888, opts->bindings = 0x23b77520, buffer[] = 0x0 [2755657728]fetch: cols=5, lf=2, opts = 0x6995888, opts->bindings = 0x23b77520, buffer[] = 0x0 [2755657728]fetch: cols=5, lf=3, opts = 0x6995888, opts->bindings = 0x23b77520, buffer[] = 0x0 [2755657728]fetch: cols=5, lf=4, opts = 0x6995888, opts->bindings = 0x23b77520, buffer[] = 0x0 [2755657728][SQLColAttributeW][2755657728]PGAPI_ColAttributes: entering..col=4 2 len=0. [2755657728]SC_describe: status = 3 [2755657728]PGAPI_ColAttributes: result = 0x23b77470, status = 3, numcols = 5 [2755657728]colAttr: col 3 field_type=1043 fi,ti=0x0,0x0 [2755657728]getCharColumnSizeX: type=1043, atttypmod=-1, adtsize_or=128, unknown = 100 [2755657728]getCharColumnSizeX: type=1043, atttypmod=-1, adtsize_or=128, unknown = -1 [2755657728]COLUMN_TYPE=-9 [2755657728][SQLGetData][2755657728]PGAPI_GetData: enter, stmt=0x6995800 icol=4 [2755657728] num_rows = 1 [2755657728] value = 'TABLE' [2755657728]**** PGAPI_GetData: icol = 3, target_type = -8, field_type = 1043, value = 'TABLE' [2755657728]copy_and_convert: field_type = 1043, fctype = -8, value = 'TABLE', cbValueMax=4094 [2755657728]DEFAULT: len = 20, ptr = 'T' [2755657728] SQL_C_WCHAR, default: len = 20, cbValueMax = 4092, rgbValueBindRow = 'T' [2755657728][[SQLFetch]][2755657728]PGAPI_ExtendedFetch: stmt=0x6995800 rowsetSize=1 [2755657728]SQL_FETCH_NEXT: num_tuples=1, currtuple=0, rowst=0 [2755657728][SQLGetInfoW][2755657728]PGAPI_GetInfo: entering...fInfoType=106 [2755657728]PGAPI_GetInfo: p='', len=2, value=0, cbMax=2 [2755657728][[SQLAllocHandle]][2755657728]PGAPI_AllocStmt: entering... [2755657728]**** PGAPI_AllocStmt: hdbc = 0x5041c00, stmt = 0x511d600 [2755657728]CC_add_statement: self=0x5041c00, stmt=0x511d600 [2755657728][SQLGetStmtAttrW][2755657728]PGAPI_GetStmtAttr Handle=0x511d600 10010 [2755657728][SQLGetStmtAttrW][2755657728]PGAPI_GetStmtAttr Handle=0x511d600 10011 [2755657728][SQLGetStmtAttrW][2755657728]PGAPI_GetStmtAttr Handle=0x511d600 10012 [2755657728][SQLGetStmtAttrW][2755657728]PGAPI_GetStmtAttr Handle=0x511d600 10013 [2755657728][SQLTablesW][2755657728]PGAPI_Tables: entering...stmt=0x511d600 scnm=0x0 len=-1 [2755657728]SC_recycle_statement: self= 0x511d600 [2755657728]PGAPI_AllocStmt: entering... [2755657728]**** PGAPI_AllocStmt: hdbc = 0x5041c00, stmt = 0x5121e00 [2755657728]CC_add_statement: self=0x5041c00, stmt=0x5121e00 [2755657728]adjust in=%(1) [2755657728]adjust output=%(1) [2755657728]CC_send_query: conn=0x5041c00, query='select current_schema()' [2755657728]in QR_Constructor [2755657728]exit QR_Constructor [2755657728]num_fields = 1 [2755657728]in QR_set_num_fields [2755657728]exit QR_set_num_fields [2755657728]QR_from_PGResult: fieldname='current_schema', adtid=19, adtsize=64, atttypmod=-1 (rel,att)=(0,0) [2755657728]REALLOC: old_count = 0, size = 0 [2755657728]qresult: len=6, buffer='public' [2755657728]QResult: enter DESTRUCTOR [2755657728]QResult: in QR_close_result [2755657728]QResult: free memory in, fcount=1 [2755657728]QResult: free memory out [2755657728]QResult: exit close_result [2755657728]QResult: exit DESTRUCTOR [2755657728]PGAPI_ExecDirect: entering...0 [2755657728]SC_recycle_statement: self= 0x5121e00 [2755657728]**** PGAPI_ExecDirect: hstmt=0x5121e00, statement='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like 'public' and relname like '%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [2755657728]PGAPI_ExecDirect: calling PGAPI_Execute... [2755657728]PGAPI_Execute: entering...0 [2755657728]PGAPI_Execute: clear errors... [2755657728]PGAPI_NumParams: entering... [2755657728]SC_scanQueryAndCountParams: entering... [2755657728]prepareParameters was not called, prepare state:8 [2755657728]SC_recycle_statement: self= 0x5121e00 [2755657728]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=293, stmt='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like 'public' and relname like '%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [2755657728] stmt_with_params = 'select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like 'public' and relname like '%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [2755657728]about to begin SC_execute [2755657728] Sending SELECT statement on stmt=0x5121e00, cursor_name='SQL_CUR0x5121e00' qflag=0,1 [2755657728]CC_send_query: conn=0x5041c00, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like 'public' and relname like '%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [2755657728]in QR_Constructor [2755657728]exit QR_Constructor [2755657728]num_fields = 3 [2755657728]in QR_set_num_fields [2755657728]exit QR_set_num_fields [2755657728]QR_from_PGResult: fieldname='relname', adtid=19, adtsize=64, atttypmod=-1 (rel,att)=(1259,1) [2755657728]QR_from_PGResult: fieldname='nspname', adtid=19, adtsize=64, atttypmod=-1 (rel,att)=(2615,1) [2755657728]QR_from_PGResult: fieldname='relkind', adtid=18, adtsize=1, atttypmod=-1 (rel,att)=(1259,16) [2755657728]REALLOC: old_count = 0, size = 0 [2755657728]qresult: len=10, buffer='test_table' [2755657728]qresult: len=6, buffer='public' [2755657728]qresult: len=1, buffer='r' [2755657728] done sending the query: [2755657728]extend_column_bindings: entering ... self=0x5121e88, bindings_allocated=0, num_columns=3 [2755657728]exit extend_column_bindings=0xc2d8820 [2755657728]SC_set_Result(5121e00, 23b77aa0)[2755657728]QResult: enter DESTRUCTOR [2755657728]retval=0 [2755657728]PGAPI_ExecDirect: returned 0 from PGAPI_Execute [2755657728]PGAPI_BindCol: entering... [2755657728]**** PGAPI_BindCol: stmt = 0x5121e00, icol = 1 [2755657728]**** : fCType=-9999 rgb=0xbfffbd98 valusMax=128 pcb=0xbfffba80 [2755657728]extend_getdata_info: entering ... self=0x5121f7c, gdata_allocated=0, num_columns=1 [2755657728]exit extend_gdata_info=0xc2d8770 [2755657728] bound buffer[0] = 0xbfffbd98 [2755657728]PGAPI_BindCol: entering... [2755657728]**** PGAPI_BindCol: stmt = 0x5121e00, icol = 2 [2755657728]**** : fCType=-9999 rgb=0xbfffbd18 valusMax=128 pcb=0xbfffba78 [2755657728]extend_getdata_info: entering ... self=0x5121f7c, gdata_allocated=1, num_columns=2 [2755657728]exit extend_gdata_info=0xc2d8870 [2755657728] bound buffer[1] = 0xbfffbd18 [2755657728]PGAPI_BindCol: entering... [2755657728]**** PGAPI_BindCol: stmt = 0x5121e00, icol = 3 [2755657728]**** : fCType=-9999 rgb=0xbfffbc98 valusMax=128 pcb=0xbfffba7c [2755657728]extend_getdata_info: entering ... self=0x5121f7c, gdata_allocated=2, num_columns=3 [2755657728]exit extend_gdata_info=0xc2d8890 [2755657728] bound buffer[2] = 0xbfffbc98 [2755657728]in QR_Constructor [2755657728]exit QR_Constructor [2755657728]SC_set_Result(511d600, c2d8770)[2755657728]QResult: enter DESTRUCTOR [2755657728]extend_column_bindings: entering ... self=0x511d688, bindings_allocated=0, num_columns=5 [2755657728]exit extend_column_bindings=0xc2d88e0 [2755657728]in QR_set_num_fields [2755657728]exit QR_set_num_fields [2755657728]PGAPI_Fetch: stmt = 0x5121e00, stmt->result= 0x23b77aa0 [2755657728]fetch_cursor=0, 0x23b77aa0->total_read=1 [2755657728]**** SC_fetch: non-cursor_result [2755657728]fetch: cols=3, lf=0, opts = 0x5121e88, opts->bindings = 0xc2d8820, buffer[] = 0xbfffbd98 [2755657728]type = 19, atttypmod = -1 [2755657728]value = 'test_table' [2755657728]copy_and_convert: field_type = 19, fctype = -9999, value = 'test_table', cbValueMax=128 [2755657728]DEFAULT: len = 10, ptr = 'test_table' [2755657728] SQL_C_CHAR, default: len = 10, cbValueMax = 128, rgbValueBindRow = 'test_table' [2755657728]copy_and_convert: retval = 0 [2755657728]fetch: cols=3, lf=1, opts = 0x5121e88, opts->bindings = 0xc2d8820, buffer[] = 0xbfffbd18 [2755657728]type = 19, atttypmod = -1 [2755657728]value = 'public' [2755657728]copy_and_convert: field_type = 19, fctype = -9999, value = 'public', cbValueMax=128 [2755657728]DEFAULT: len = 6, ptr = 'public' [2755657728] SQL_C_CHAR, default: len = 6, cbValueMax = 128, rgbValueBindRow = 'public' [2755657728]copy_and_convert: retval = 0 [2755657728]fetch: cols=3, lf=2, opts = 0x5121e88, opts->bindings = 0xc2d8820, buffer[] = 0xbfffbc98 [2755657728]type = 18, atttypmod = -1 [2755657728]value = 'r' [2755657728]copy_and_convert: field_type = 18, fctype = -9999, value = 'r', cbValueMax=128 [2755657728]DEFAULT: len = 1, ptr = 'r' [2755657728] SQL_C_CHAR, default: len = 1, cbValueMax = 128, rgbValueBindRow = 'r' [2755657728]copy_and_convert: retval = 0 [2755657728]table_name='test_table', prefix[0]='dd_' [2755657728]PGAPI_Tables: table_name = 'test_table' [2755657728]PGAPI_Fetch: stmt = 0x5121e00, stmt->result= 0x23b77aa0 [2755657728]fetch_cursor=0, 0x23b77aa0->total_read=1 [2755657728]PGAPI_FreeStmt: entering...hstmt=0x5121e00, fOption=1 [2755657728]QResult: enter DESTRUCTOR [2755657728]QResult: in QR_close_result [2755657728]QResult: free memory in, fcount=1 [2755657728]QResult: free memory out [2755657728]QResult: exit close_result [2755657728]QResult: exit DESTRUCTOR [2755657728]SC_init_Result(5121e00)[2755657728]SC_Destructor: self=0x5121e00, self->result=0x0, self->hdbc=0x5041c00 [2755657728]reset_a_column_binding: entering ... self=0x5121e88, bindings_allocated=3, icol=1 [2755657728]reset_a_column_binding: entering ... self=0x5121e88, bindings_allocated=3, icol=2 [2755657728]reset_a_column_binding: entering ... self=0x5121e88, bindings_allocated=3, icol=3 [2755657728]APD_free_params: ENTER, self=0x5121f08 [2755657728]IPD_free_params: ENTER, self=0x5121f48 [2755657728]PDATA_free_params: ENTER, self=0x5121fc4 [2755657728]SC_Destructor: EXIT [2755657728]PGAPI_Tables: EXIT, stmt=0x511d600, ret=0 [2755657728][SQLNumResultCols][2755657728]PGAPI_NumResultCols: entering... [2755657728]SC_describe: status = 3 [2755657728]PGAPI_NumResultCols: result = 0xc2d8770, status = 3, numcols = 5 [2755657728][[SQLFetch]][2755657728]PGAPI_ExtendedFetch: stmt=0x511d600 rowsetSize=1 [2755657728]SQL_FETCH_NEXT: num_tuples=1, currtuple=-1, rowst=-1 [2755657728]PGAPI_ExtendedFetch: new currTuple = -1 [2755657728]fetch_cursor=0, 0xc2d8770->total_read=0 [2755657728]**** SC_fetch: non-cursor_result [2755657728]extend_getdata_info: entering ... self=0x511d77c, gdata_allocated=0, num_columns=5 [2755657728]exit extend_gdata_info=0xc2d8270 [2755657728]fetch: cols=5, lf=0, opts = 0x511d688, opts->bindings = 0xc2d88e0, buffer[] = 0x0 [2755657728]fetch: cols=5, lf=1, opts = 0x511d688, opts->bindings = 0xc2d88e0, buffer[] = 0x0 [2755657728]fetch: cols=5, lf=2, opts = 0x511d688, opts->bindings = 0xc2d88e0, buffer[] = 0x0 [2755657728]fetch: cols=5, lf=3, opts = 0x511d688, opts->bindings = 0xc2d88e0, buffer[] = 0x0 [2755657728]fetch: cols=5, lf=4, opts = 0x511d688, opts->bindings = 0xc2d88e0, buffer[] = 0x0 [2755657728][SQLColAttributeW][2755657728]PGAPI_ColAttributes: entering..col=1 2 len=0. [2755657728]SC_describe: status = 3 [2755657728]PGAPI_ColAttributes: result = 0xc2d8770, status = 3, numcols = 5 [2755657728]colAttr: col 0 field_type=1043 fi,ti=0x0,0x0 [2755657728]getCharColumnSizeX: type=1043, atttypmod=-1, adtsize_or=128, unknown = 100 [2755657728]getCharColumnSizeX: type=1043, atttypmod=-1, adtsize_or=128, unknown = -1 [2755657728]COLUMN_TYPE=-9 [2755657728][SQLGetData][2755657728]PGAPI_GetData: enter, stmt=0x511d600 icol=1 [2755657728] num_rows = 1 [2755657728] value = 'postgres' [2755657728]**** PGAPI_GetData: icol = 0, target_type = -8, field_type = 1043, value = 'postgres' [2755657728]copy_and_convert: field_type = 1043, fctype = -8, value = 'postgres', cbValueMax=4094 [2755657728]DEFAULT: len = 32, ptr = 'p' [2755657728] SQL_C_WCHAR, default: len = 32, cbValueMax = 4092, rgbValueBindRow = 'p' [2755657728][SQLColAttributeW][2755657728]PGAPI_ColAttributes: entering..col=2 2 len=0. [2755657728]SC_describe: status = 3 [2755657728]PGAPI_ColAttributes: result = 0xc2d8770, status = 3, numcols = 5 [2755657728]colAttr: col 1 field_type=1043 fi,ti=0x0,0x0 [2755657728]getCharColumnSizeX: type=1043, atttypmod=-1, adtsize_or=128, unknown = 100 [2755657728]getCharColumnSizeX: type=1043, atttypmod=-1, adtsize_or=128, unknown = -1 [2755657728]COLUMN_TYPE=-9 [2755657728][SQLGetData][2755657728]PGAPI_GetData: enter, stmt=0x511d600 icol=2 [2755657728] num_rows = 1 [2755657728] value = 'public' [2755657728]**** PGAPI_GetData: icol = 1, target_type = -8, field_type = 1043, value = 'public' [2755657728]copy_and_convert: field_type = 1043, fctype = -8, value = 'public', cbValueMax=4094 [2755657728]DEFAULT: len = 24, ptr = 'p' [2755657728] SQL_C_WCHAR, default: len = 24, cbValueMax = 4092, rgbValueBindRow = 'p' [2755657728][SQLColAttributeW][2755657728]PGAPI_ColAttributes: entering..col=3 2 len=0. [2755657728]SC_describe: status = 3 [2755657728]PGAPI_ColAttributes: result = 0xc2d8770, status = 3, numcols = 5 [2755657728]colAttr: col 2 field_type=1043 fi,ti=0x0,0x0 [2755657728]getCharColumnSizeX: type=1043, atttypmod=-1, adtsize_or=128, unknown = 100 [2755657728]getCharColumnSizeX: type=1043, atttypmod=-1, adtsize_or=128, unknown = -1 [2755657728]COLUMN_TYPE=-9 [2755657728][SQLGetData][2755657728]PGAPI_GetData: enter, stmt=0x511d600 icol=3 [2755657728] num_rows = 1 [2755657728] value = 'test_table' [2755657728]**** PGAPI_GetData: icol = 2, target_type = -8, field_type = 1043, value = 'test_table' [2755657728]copy_and_convert: field_type = 1043, fctype = -8, value = 'test_table', cbValueMax=4094 [2755657728]DEFAULT: len = 40, ptr = 't' [2755657728] SQL_C_WCHAR, default: len = 40, cbValueMax = 4092, rgbValueBindRow = 't' [2755657728][SQLColAttributeW][2755657728]PGAPI_ColAttributes: entering..col=4 2 len=0. [2755657728]SC_describe: status = 3 [2755657728]PGAPI_ColAttributes: result = 0xc2d8770, status = 3, numcols = 5 [2755657728]colAttr: col 3 field_type=1043 fi,ti=0x0,0x0 [2755657728]getCharColumnSizeX: type=1043, atttypmod=-1, adtsize_or=128, unknown = 100 [2755657728]getCharColumnSizeX: type=1043, atttypmod=-1, adtsize_or=128, unknown = -1 [2755657728]COLUMN_TYPE=-9 [2755657728][SQLGetData][2755657728]PGAPI_GetData: enter, stmt=0x511d600 icol=4 [2755657728] num_rows = 1 [2755657728] value = 'TABLE' [2755657728]**** PGAPI_GetData: icol = 3, target_type = -8, field_type = 1043, value = 'TABLE' [2755657728]copy_and_convert: field_type = 1043, fctype = -8, value = 'TABLE', cbValueMax=4094 [2755657728]DEFAULT: len = 20, ptr = 'T' [2755657728] SQL_C_WCHAR, default: len = 20, cbValueMax = 4092, rgbValueBindRow = 'T' [2755657728][[SQLFetch]][2755657728]PGAPI_ExtendedFetch: stmt=0x511d600 rowsetSize=1 [2755657728]SQL_FETCH_NEXT: num_tuples=1, currtuple=0, rowst=0 [2755657728][SQLFreeStmt][2755657728]PGAPI_FreeStmt: entering...hstmt=0x511d600, fOption=3 [2755657728]APD_free_params: ENTER, self=0x511d708 [2755657728]IPD_free_params: ENTER, self=0x511d748 [2755657728]PDATA_free_params: ENTER, self=0x511d7c4 [2755657728][SQLFreeStmt][2755657728]PGAPI_FreeStmt: entering...hstmt=0x511d600, fOption=2 [2755657728]reset_a_column_binding: entering ... self=0x511d688, bindings_allocated=5, icol=1 [2755657728]reset_a_column_binding: entering ... self=0x511d688, bindings_allocated=5, icol=2 [2755657728]reset_a_column_binding: entering ... self=0x511d688, bindings_allocated=5, icol=3 [2755657728]reset_a_column_binding: entering ... self=0x511d688, bindings_allocated=5, icol=4 [2755657728]reset_a_column_binding: entering ... self=0x511d688, bindings_allocated=5, icol=5 [2755657728][SQLFreeStmt][2755657728]PGAPI_FreeStmt: entering...hstmt=0x511d600, fOption=0 [2755657728]SC_recycle_statement: self= 0x511d600 [2755657728]SC_set_Result(511d600, 0)[2755657728]QResult: enter DESTRUCTOR [2755657728]QResult: in QR_close_result [2755657728]QResult: free memory in, fcount=1 [2755657728]QResult: free memory out [2755657728]QResult: exit close_result [2755657728]QResult: exit DESTRUCTOR [2755657728]PDATA_free_params: ENTER, self=0x511d7c4 [2755657728][[SQLFreeHandle]][2755657728]PGAPI_FreeStmt: entering...hstmt=0x511d600, fOption=1 [2755657728]QResult: enter DESTRUCTOR [2755657728]SC_init_Result(511d600)[2755657728]SC_Destructor: self=0x511d600, self->result=0x0, self->hdbc=0x5041c00 [2755657728]reset_a_column_binding: entering ... self=0x511d688, bindings_allocated=5, icol=1 [2755657728]reset_a_column_binding: entering ... self=0x511d688, bindings_allocated=5, icol=2 [2755657728]reset_a_column_binding: entering ... self=0x511d688, bindings_allocated=5, icol=3 [2755657728]reset_a_column_binding: entering ... self=0x511d688, bindings_allocated=5, icol=4 [2755657728]reset_a_column_binding: entering ... self=0x511d688, bindings_allocated=5, icol=5 [2755657728]APD_free_params: ENTER, self=0x511d708 [2755657728]IPD_free_params: ENTER, self=0x511d748 [2755657728]PDATA_free_params: ENTER, self=0x511d7c4 [2755657728]SC_Destructor: EXIT [2755657728][SQLFreeStmt][2755657728]PGAPI_FreeStmt: entering...hstmt=0x6995800, fOption=3 [2755657728]APD_free_params: ENTER, self=0x6995908 [2755657728]IPD_free_params: ENTER, self=0x6995948 [2755657728]PDATA_free_params: ENTER, self=0x69959c4 [2755657728][SQLFreeStmt][2755657728]PGAPI_FreeStmt: entering...hstmt=0x6995800, fOption=2 [2755657728]reset_a_column_binding: entering ... self=0x6995888, bindings_allocated=5, icol=1 [2755657728]reset_a_column_binding: entering ... self=0x6995888, bindings_allocated=5, icol=2 [2755657728]reset_a_column_binding: entering ... self=0x6995888, bindings_allocated=5, icol=3 [2755657728]reset_a_column_binding: entering ... self=0x6995888, bindings_allocated=5, icol=4 [2755657728]reset_a_column_binding: entering ... self=0x6995888, bindings_allocated=5, icol=5 [2755657728][SQLFreeStmt][2755657728]PGAPI_FreeStmt: entering...hstmt=0x6995800, fOption=0 [2755657728]SC_recycle_statement: self= 0x6995800 [2755657728]SC_set_Result(6995800, 0)[2755657728]QResult: enter DESTRUCTOR [2755657728]QResult: in QR_close_result [2755657728]QResult: free memory in, fcount=1 [2755657728]QResult: free memory out [2755657728]QResult: exit close_result [2755657728]QResult: exit DESTRUCTOR [2755657728]PDATA_free_params: ENTER, self=0x69959c4 [2755657728][[SQLFreeHandle]][2755657728]PGAPI_FreeStmt: entering...hstmt=0x6995800, fOption=1 [2755657728]QResult: enter DESTRUCTOR [2755657728]SC_init_Result(6995800)[2755657728]SC_Destructor: self=0x6995800, self->result=0x0, self->hdbc=0x5041c00 [2755657728]reset_a_column_binding: entering ... self=0x6995888, bindings_allocated=5, icol=1 [2755657728]reset_a_column_binding: entering ... self=0x6995888, bindings_allocated=5, icol=2 [2755657728]reset_a_column_binding: entering ... self=0x6995888, bindings_allocated=5, icol=3 [2755657728]reset_a_column_binding: entering ... self=0x6995888, bindings_allocated=5, icol=4 [2755657728]reset_a_column_binding: entering ... self=0x6995888, bindings_allocated=5, icol=5 [2755657728]APD_free_params: ENTER, self=0x6995908 [2755657728]IPD_free_params: ENTER, self=0x6995948 [2755657728]PDATA_free_params: ENTER, self=0x69959c4 [2755657728]SC_Destructor: EXIT