CC_connect: entering... CC_connect(): DSN = 'Cables', server = 'sirius', port = '5432', database = 'cables', username = 'control', password='lemon5Pi' connecting to the server socket... connection to the server socket succeeded. sent the authentication block. sent the authentication block successfully. gonna do authentication sending an empty query... send_query(): conn=27030288, query=' ' send_query: done sending query in QR_Constructor exit QR_Constructor read 2, global_socket_buffersize=4096 send_query: got id = 'I' 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 = 27030288, stmt = 27067856 CC_add_statement: self=27030288, stmt=27067856 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=27067856, statement='set DateStyle to 'ISO'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 27067856 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=27067856 send_query(): conn=27030288, query='set DateStyle to 'ISO'' send_query: done sending query in QR_Constructor exit QR_Constructor read 46, global_socket_buffersize=4096 send_query: got id = 'E' send_query: 'E' - WARN:parser: syntax error at or near "set" STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query' CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='WARN:parser: syntax error at or near "set" ' PGAPI_ExecDirect: returned -1 from PGAPI_Execute CC_send_settings: result -1, status 0 from set DateStyle PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=27067856, 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= 27067856 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=27067956 recycle statement: self= 27067856 APD_free_params: ENTER, self=27067956 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=27067856 send_query(): conn=27030288, query='set geqo to 'OFF'' send_query: done sending query in QR_Constructor exit QR_Constructor read 46, global_socket_buffersize=4096 send_query: got id = 'E' send_query: 'E' - WARN:parser: syntax error at or near "set" STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query' CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='WARN:parser: syntax error at or near "set" ' PGAPI_ExecDirect: returned -1 from PGAPI_Execute CC_send_settings: result -1, status 0 from set geqo PGAPI_FreeStmt: entering...hstmt=27067856, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=27067856, self->result=0, self->hdbc=27030288 APD_free_params: ENTER, self=27067956 SC_Destructor: EXIT CC_lookup_lo: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 27030288, stmt = 27067856 CC_add_statement: self=27030288, stmt=27067856 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=27067856, statement='select oid from pg_type where typname='lo'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 27067856 PGAPI_Execute: copying statement params: trans_status=1, len=42, stmt='select oid from pg_type where typname='lo'' stmt_with_params = 'declare SQL_CUR019D05D0 cursor for select oid from pg_type where typname='lo'' about to begin a transaction on statement = 27067856 send_query(): conn=27030288, query='BEGIN' send_query: done sending query in QR_Constructor exit QR_Constructor read 7, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - BEGIN send_query: setting cmdbuffer = 'BEGIN' send_query: returning res = 27067488 read 2, global_socket_buffersize=4096 send_query: got id = 'I' CC_begin: sending BEGIN! QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR Sending SELECT statement on stmt=27067856, cursor_name='SQL_CUR019D05D0' send_query(): conn=27030288, query='declare SQL_CUR019D05D0 cursor for select oid from pg_type where typname='lo'' send_query: done sending query in QR_Constructor exit QR_Constructor read 8, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - SELECT send_query: setting cmdbuffer = 'SELECT' send_query: returning res = 27067488 read 2, global_socket_buffersize=4096 send_query: got id = 'I' QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR send_query(): conn=27030288, query='fetch 100 in SQL_CUR019D05D0' send_query: done sending query in QR_Constructor exit QR_Constructor read 30, global_socket_buffersize=4096 send_query: got id = 'P' send_query: got id = 'T' QR_fetch_tuples: cursor = 'SQL_CUR019D05D0', self->cursor=0 num_fields = 1 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 read 7, global_socket_buffersize=4096 end of tuple list -- setting inUse to false: this = 27067488 _next_tuple: 'C': DONE (fcount == 0) done sending the query: extend_column_bindings: entering ... self=27067904, bindings_allocated=0, num_columns=1 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute PGAPI_Fetch: stmt = 27067856, stmt->result= 27067488 manual_result = 0, use_declarefetch = 1 next_tuple: fcount < CACHE_SIZE: fcount = 0, fetch_count = 0 **** SC_fetch: end_tuples PGAPI_FreeStmt: entering...hstmt=27067856, fOption=1 QResult: in DESTRUCTOR QResult: closing cursor: 'close SQL_CUR019D05D0' send_query(): conn=27030288, query='close SQL_CUR019D05D0' send_query: done sending query in QR_Constructor exit QR_Constructor read 7, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - CLOSE send_query: setting cmdbuffer = 'CLOSE' send_query: returning res = 27074448 read 2, global_socket_buffersize=4096 send_query: got id = 'I' QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR CC_cursor_count: self=27030288, num_stmts=16 CC_cursor_count: returning 0 QResult: END transaction on conn=27030288 send_query(): conn=27030288, query='COMMIT' send_query: done sending query in QR_Constructor exit QR_Constructor read 49, global_socket_buffersize=4096 send_query: got id = 'E' send_query: 'E' - WARN:parser: syntax error at or near "COMMIT" QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR CC_commit: sending COMMIT! QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=27067856, self->result=0, self->hdbc=27030288 reset_a_column_binding: entering ... self=27067904, bindings_allocated=1, icol=1 APD_free_params: ENTER, self=27067956 SC_Destructor: EXIT CC_lookup_pg_version: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 27030288, stmt = 27067856 CC_add_statement: self=27030288, stmt=27067856 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=27067856, statement='select version()' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 27067856 PGAPI_Execute: copying statement params: trans_status=3, len=16, stmt='select version()' stmt_with_params = 'declare SQL_CUR019D05D0 cursor for select version()' Sending SELECT statement on stmt=27067856, cursor_name='SQL_CUR019D05D0' send_query(): conn=27030288, query='declare SQL_CUR019D05D0 cursor for select version()' send_query: done sending query in QR_Constructor exit QR_Constructor read 50, global_socket_buffersize=4096 send_query: got id = 'E' send_query: 'E' - WARN:parser: syntax error at or near "version" done sending the query: send_query(): conn=27030288, query='ROLLBACK' send_query: done sending query in QR_Constructor exit QR_Constructor read 51, global_socket_buffersize=4096 send_query: got id = 'E' send_query: 'E' - WARN:parser: syntax error at or near "ROLLBACK" QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR CC_abort: sending ABORT! STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query' CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='WARN:parser: syntax error at or near "ROLLBACK" ' PGAPI_ExecDirect: returned -1 from PGAPI_Execute PGAPI_FreeStmt: entering...hstmt=27067856, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=27067856, self->result=0, self->hdbc=27030288 APD_free_params: ENTER, self=27067956 SC_Destructor: EXIT CC_connect: returning... szConnStrOut = 'DSN=Cables;DATABASE=cables;SERVER=sirius;PORT=5432;UID=control;PWD=lemon5Pi;ReadOnly=1;Protocol=6.2;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=1;ShowSystemTables=1;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=2;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=1;Ksqo=0;UseDeclareFetch=1;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=1;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0' len=495,1024 PGAPI_DriverConnect: returning 0 [SQLError]**** PGAPI_Error: henv=0, hdbc=27030288 hstmt=0 **** PGAPI_ConnectError: hdbc=27030288 <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=1, cbMax=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=24 PGAPI_GetInfo: p='', len=2, value=1, cbMax=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=2 PGAPI_GetInfo: p='Cables', len=0, value=0, cbMax=2048 [SQLAllocStmt]PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 27030288, stmt = 27067856 CC_add_statement: self=27030288, stmt=27067856 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=1 PGAPI_GetInfo: p='', len=2, value=0, cbMax=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=25 PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=2048 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=6 PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=2048 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=14 PGAPI_GetInfo: p='', len=0, value=0, cbMax=2048 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=74 PGAPI_GetInfo: p='', len=2, value=2, cbMax=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=75 PGAPI_GetInfo: p='', len=2, value=1, cbMax=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=41 PGAPI_GetInfo: p='', len=0, value=0, cbMax=2048 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=84 PGAPI_GetInfo: p='', len=2, value=0, cbMax=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=14 PGAPI_GetInfo: p='', len=0, value=0, cbMax=130 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=42 PGAPI_GetInfo: p='', len=0, value=0, cbMax=130 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=27067856, fOption=0 recycle statement: self= 27067856 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=27067856, fOption=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=32 PGAPI_GetInfo: p='', len=2, value=0, cbMax=2 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=27067856, fOption=0 recycle statement: self= 27067856 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=27067856, fOption=2 [SQLTables]PGAPI_Tables: entering...stmt=27067856 scnm=0 len=-3 PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 27030288, stmt = 27067360 CC_add_statement: self=27030288, stmt=27067360 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=27067360, statement='select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and usesysid = relowner order by relname' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 27067360 PGAPI_Execute: copying statement params: trans_status=3, len=149, stmt='select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and usesysid = relowner order by relname' stmt_with_params = 'declare SQL_CUR019D03E0 cursor for select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and usesysid = relowner order by relname' Sending SELECT statement on stmt=27067360, cursor_name='SQL_CUR019D03E0' send_query(): conn=27030288, query='declare SQL_CUR019D03E0 cursor for select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and usesysid = relowner order by relname' send_query: done sending query in QR_Constructor exit QR_Constructor read 71, global_socket_buffersize=4096 send_query: got id = 'E' send_query: 'E' - WARN:Named portals may only be used in begin/end transaction blocks. done sending the query: send_query(): conn=27030288, query='ROLLBACK' send_query: done sending query in QR_Constructor exit QR_Constructor read 51, global_socket_buffersize=4096 send_query: got id = 'E' send_query: 'E' - WARN:parser: syntax error at or near "ROLLBACK" QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR CC_abort: sending ABORT! STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query' CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='WARN:parser: syntax error at or near "ROLLBACK" ' PGAPI_ExecDirect: returned -1 from PGAPI_Execute STATEMENT ERROR: func=PGAPI_Tables, desc='', errnum=7, errmsg='WARN:parser: syntax error at or near "ROLLBACK" ' CONN ERROR: func=PGAPI_Tables, desc='', errnum=110, errmsg='WARN:parser: syntax error at or near "ROLLBACK" ' PGAPI_FreeStmt: entering...hstmt=27067360, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=27067360, self->result=0, self->hdbc=27030288 APD_free_params: ENTER, self=27067460 SC_Destructor: EXIT [SQLError]**** PGAPI_Error: henv=0, hdbc=0 hstmt=27067856 **** PGAPI_StmtError: hstmt=27067856 <512> SC_get_error: status = 7, msg = #WARN:parser: syntax error at or near "ROLLBACK" # szSqlState = 'S1000',len=48, szError='WARN:parser: syntax error at or near "ROLLBACK" ' **** PGAPI_Error exit code=0 [SQLError]**** PGAPI_Error: henv=0, hdbc=0 hstmt=27067856 **** PGAPI_StmtError: hstmt=27067856 <512> SC_Get_error returned nothing. **** PGAPI_Error exit code=100 [SQLError]**** PGAPI_Error: henv=0, hdbc=0 hstmt=27067856 **** PGAPI_StmtError: hstmt=27067856 <512> SC_Get_error returned nothing. **** PGAPI_Error exit code=100 [SQLError]**** PGAPI_Error: henv=0, hdbc=0 hstmt=27067856 **** PGAPI_StmtError: hstmt=27067856 <512> SC_Get_error returned nothing. **** PGAPI_Error exit code=100 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=27067856, fOption=1 SC_Destructor: self=27067856, self->result=0, self->hdbc=27030288 APD_free_params: ENTER, self=27067956 SC_Destructor: EXIT [SQLDisconnect]PGAPI_Disconnect: entering...