CC_connect: entering... CC_connect(): DSN = 'gesdocPG-badalona', server = 'cibalix2', port = '5432', database = 'gesdoc', username = 'mjuan', password='mjuan' 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 = 3 in AUTH_REQ_PASSWORD past need password past flush 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=57570000, 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 = 57570000, stmt = 57607744 CC_add_statement: self=57570000, stmt=57607744 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=57607744, statement='set DateStyle to 'ISO'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 57607744 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=57607744 send_query(): conn=57570000, 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 = 57607440 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=57607744, 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= 57607744 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=57607844 recycle statement: self= 57607744 APD_free_params: ENTER, self=57607844 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=57607744 send_query(): conn=57570000, 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 = 57607440 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=57607744, 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= 57607744 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=57607844 recycle statement: self= 57607744 APD_free_params: ENTER, self=57607844 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=57607744 send_query(): conn=57570000, 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 = 57607440 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=57607744, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=57607744, self->result=0, self->hdbc=57570000 APD_free_params: ENTER, self=57607844 SC_Destructor: EXIT CC_lookup_lo: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 57570000, stmt = 57607744 CC_add_statement: self=57570000, stmt=57607744 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=57607744, statement='select oid from pg_type where typname='lo'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 57607744 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=57607744, cursor_name='SQL_CUR036F0640' send_query(): conn=57570000, 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 = 57607376 _next_tuple: 'C': DONE (fcount == 0) send_query: got id = 'Z' done sending the query: extend_column_bindings: entering ... self=57607792, bindings_allocated=0, num_columns=1 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute PGAPI_Fetch: stmt = 57607744, stmt->result= 57607376 manual_result = 0, use_declarefetch = 0 PGAPI_FreeStmt: entering...hstmt=57607744, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=57607744, self->result=0, self->hdbc=57570000 reset_a_column_binding: entering ... self=57607792, bindings_allocated=1, icol=1 APD_free_params: ENTER, self=57607844 SC_Destructor: EXIT CC_lookup_pg_version: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 57570000, stmt = 57607744 CC_add_statement: self=57570000, stmt=57607744 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=57607744, statement='select version()' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 57607744 PGAPI_Execute: copying statement params: trans_status=1, len=16, stmt='select version()' stmt_with_params = 'select version()' Sending SELECT statement on stmt=57607744, cursor_name='SQL_CUR036F0640' send_query(): conn=57570000, query='select version()' send_query: done sending query in QR_Constructor exit QR_Constructor read 102, 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=59, buffer='PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96' end of tuple list -- setting inUse to false: this = 57607440 _next_tuple: 'C' fetch_max && fcount = 1 send_query: got id = 'Z' done sending the query: extend_column_bindings: entering ... self=57607792, bindings_allocated=0, num_columns=1 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute PGAPI_Fetch: stmt = 57607744, stmt->result= 57607440 manual_result = 0, use_declarefetch = 0 **** SC_fetch: manual_result fetch: cols=1, lf=0, opts = 57607792, opts->bindings = 57606352, buffer[] = 0 PGAPI_GetData: enter, stmt=57607744 num_rows = 1 value = 'PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96' **** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value = 'PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96' copy_and_convert: field_type = 25, fctype = 1, value = 'PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96', cbValueMax=128 DEFAULT: len = 59, ptr = 'PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96' SQL_C_CHAR, default: len = 59, cbValueMax = 128, rgbValueBindRow = 'PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96' Got the PostgreSQL version string: 'PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96' Extracted PostgreSQL version number: '7.1' PGAPI_FreeStmt: entering...hstmt=57607744, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=1 row = 0, num_fields = 1 free [lf=0] 57606416 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=57607744, self->result=0, self->hdbc=57570000 reset_a_column_binding: entering ... self=57607792, bindings_allocated=1, icol=1 APD_free_params: ENTER, self=57607844 SC_Destructor: EXIT CC_lookup_characterset: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 57570000, stmt = 57607744 CC_add_statement: self=57570000, stmt=57607744 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=57607744, statement='Show Client_Encoding' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 57607744 PGAPI_Execute: copying statement params: trans_status=1, len=20, stmt='Show Client_Encoding' stmt_with_params = 'Show Client_Encoding' it's NOT a select statement: stmt=57607744 send_query(): conn=57570000, query='Show Client_Encoding' send_query: done sending query in QR_Constructor exit QR_Constructor read 48, global_socket_buffersize=4096 send_query: got id = 'N' ~~~ NOTICE: 'NOTICE: Current client encoding is SQL_ASCII ' read 16, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - SHOW VARIABLE send_query: setting cmdbuffer = 'SHOW VARIABLE' send_query: returning res = 57607440 send_query: got id = 'Z' PGAPI_ExecDirect: returned 1 from PGAPI_Execute **** PGAPI_Error: henv=0, hdbc=0 hstmt=57607744 **** PGAPI_StmtError: hstmt=57607744 <128> SC_get_error: status = -1, msg = #NOTICE: Current client encoding is SQL_ASCII # szSqlState = '00000',len=46, szError='NOTICE: Current client encoding is SQL_ASCII ' **** PGAPI_Error exit code=0 PGAPI_FreeStmt: entering...hstmt=57607744, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=57607744, self->result=0, self->hdbc=57570000 APD_free_params: ENTER, self=57607844 SC_Destructor: EXIT CC_connect: returning... PGAPI_Connect: returning... [SQLError]**** PGAPI_Error: henv=0, hdbc=57570000 hstmt=0 **** PGAPI_ConnectError: hdbc=57570000 <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=79 PGAPI_GetInfo: p='', len=4, value=3, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=111 PGAPI_GetInfo: p='N', len=0, value=0, cbMax=4 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=0 PGAPI_GetInfo: p='', len=2, value=128, cbMax=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=1 PGAPI_GetInfo: p='', len=2, value=0, cbMax=2 [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=46 PGAPI_GetInfo: p='', len=2, value=2, cbMax=2 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=17 PGAPI_GetInfo: p='PostgreSQL', len=0, value=0, cbMax=66 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=85 PGAPI_GetInfo: p='', len=2, value=4, cbMax=2 [SQLSetConnectionOption]PGAPI_SetConnectOption: entering fOption = 102 vParam = 1 [SQLGetConnectOption]PGAPI_GetConnectOption: entering... [SQLAllocStmt]PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 57570000, stmt = 57607744 CC_add_statement: self=57570000, stmt=57607744 [SQLProcedures]PGAPI_Procedures: entering... scnm=0 len=0 recycle statement: self= 57607744 send_query(): conn=57570000, query='select '' as PROCEDURE_CAT, '' as PROCEDURE_SCHEM, proname as PROCEDURE_NAME, '' as NUM_INPUT_PARAMS, '' as NUM_OUTPUT_PARAMS, '' as NUM_RESULT_SETS, '' as REMARKS, case when prorettype = 0 then 1::int2 else 2::int2 end as PROCEDURE_TYPE from pg_proc where' send_query: done sending query in QR_Constructor exit QR_Constructor read 44, global_socket_buffersize=4096 send_query: got id = 'E' send_query: 'E' - ERROR: parser: parse error at or near "" read 1, global_socket_buffersize=4096 send_query: got id = 'Z' QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR [SQLError]**** PGAPI_Error: henv=0, hdbc=0 hstmt=57607744 **** PGAPI_StmtError: hstmt=57607744 <512> SC_get_error: status = 1, msg = #PGAPI_Procedures query error# szSqlState = 'S1000',len=28, szError='PGAPI_Procedures query error' **** PGAPI_Error exit code=0 [SQLError]**** PGAPI_Error: henv=0, hdbc=0 hstmt=57607744 **** PGAPI_StmtError: hstmt=57607744 <512> SC_Get_error returned nothing. **** PGAPI_Error exit code=100 [SQLError]**** PGAPI_Error: henv=0, hdbc=0 hstmt=57607744 **** PGAPI_StmtError: hstmt=57607744 <512> SC_Get_error returned nothing. **** PGAPI_Error exit code=100 [SQLError]**** PGAPI_Error: henv=0, hdbc=0 hstmt=57607744 **** PGAPI_StmtError: hstmt=57607744 <512> SC_Get_error returned nothing. **** PGAPI_Error exit code=100 [SQLFreeStmt]PGAPI_FreeStmt: entering...hstmt=57607744, fOption=1 SC_Destructor: self=57607744, self->result=0, self->hdbc=57570000 APD_free_params: ENTER, self=57607844 SC_Destructor: EXIT [SQLDisconnect]PGAPI_Disconnect: entering...