CC_connect: entering... CC_connect(): DSN = 'bray', server = 'localhost', port = '5432', database = 'bray', username = 'olly', password='xxxxx' 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 15, global_socket_buffersize=4096 auth got 'R' areq = 0 auth got 'K' auth got 'Z' sending an empty query... send_query(): conn=137151680, 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_lookup_pg_version: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 137151680, stmt = 137177848 CC_add_statement: self=137151680, stmt=137177848 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=137177848, statement='select version()' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 137177848 Exec_with_parameters_resolved: copying statement params: trans_status=1, len=16, stmt='select version()' stmt_with_params = 'select version()' Sending SELECT statement on stmt=137177848, cursor_name='SQL_CUR0x82d2af8' send_query(): conn=137151680, query='select version()' send_query: done sending query in QR_Constructor exit QR_Constructor read 156, 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=113, buffer='PostgreSQL 7.4beta4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 20031005 (Debian prerelease)' end of tuple list -- setting inUse to false: this = 137182304 _next_tuple: 'C' fetch_total = 1 & this_fetch = 1 send_query: got id = 'Z' done sending the query: extend_column_bindings: entering ... self=137177928, bindings_allocated=0, num_columns=1 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute PGAPI_Fetch: stmt = 137177848, stmt->result= 137182304 manual_result = 0, use_declarefetch = 0 **** SC_fetch: manual_result fetch: cols=1, lf=0, opts = 137177928, opts->bindings = 137183384, buffer[] = 0 PGAPI_GetData: enter, stmt=137177848 num_rows = 1 value = 'PostgreSQL 7.4beta4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 20031005 (Debian prerelease)' **** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value = 'PostgreSQL 7.4beta4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 20031005 (Debian prerelease)' copy_and_convert: field_type = 25, fctype = 1, value = 'PostgreSQL 7.4beta4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 20031005 (Debian prerelease)', cbValueMax=128 DEFAULT: len = 113, ptr = 'PostgreSQL 7.4beta4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 20031005 (Debian prerelease)' SQL_C_CHAR, default: len = 113, cbValueMax = 128, rgbValueBindRow = 'PostgreSQL 7.4beta4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 20031005 (Debian prerelease)' Got the PostgreSQL version string: 'PostgreSQL 7.4beta4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 20031005 (Debian prerelease)' Extracted PostgreSQL version number: '7.4' PGAPI_FreeStmt: entering...hstmt=137177848, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=1 row = 0, num_fields = 1 free [lf=0] 137183248 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=137177848, self->result=0, self->hdbc=137151680 reset_a_column_binding: entering ... self=137177928, bindings_allocated=1, icol=1 APD_free_params: ENTER, self=137177980 IPD_free_params: ENTER, self=137178008 IPD_free_params: EXIT SC_Destructor: EXIT CC_send_settings: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 137151680, stmt = 137182440 CC_add_statement: self=137151680, stmt=137182440 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=137182440, statement='set DateStyle to 'ISO'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 137182440 Exec_with_parameters_resolved: 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=137182440 send_query(): conn=137151680, query='set DateStyle to 'ISO'' send_query: done sending query in QR_Constructor exit QR_Constructor read 6, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - SET send_query: setting cmdbuffer = 'SET' send_query: returning res = 137183504 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=137182440, 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= 137182440 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=137182572 IPD_free_params: ENTER, self=137182600 IPD_free_params: EXIT Exec_with_parameters_resolved: 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=137182440 send_query(): conn=137151680, query='set geqo to 'OFF'' send_query: done sending query in QR_Constructor exit QR_Constructor read 6, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - SET send_query: setting cmdbuffer = 'SET' send_query: returning res = 137183504 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=137182440, statement='set extra_float_digits to 2' 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= 137182440 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=137182572 IPD_free_params: ENTER, self=137182600 IPD_free_params: EXIT Exec_with_parameters_resolved: copying statement params: trans_status=1, len=27, stmt='set extra_float_digits to 2' stmt_with_params = 'set extra_float_digits to 2' it's NOT a select statement: stmt=137182440 send_query(): conn=137151680, query='set extra_float_digits to 2' send_query: done sending query in QR_Constructor exit QR_Constructor read 6, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - SET send_query: setting cmdbuffer = 'SET' send_query: returning res = 137183504 send_query: got id = 'Z' PGAPI_ExecDirect: returned 0 from PGAPI_Execute CC_send_settings: result 0, status 1 from set extra_float_digits PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=137182440, statement='SET SEARCH_PATH TO prod, public' 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= 137182440 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR APD_free_params: ENTER, self=137182572 IPD_free_params: ENTER, self=137182600 IPD_free_params: EXIT Exec_with_parameters_resolved: copying statement params: trans_status=1, len=31, stmt='SET SEARCH_PATH TO prod, public' stmt_with_params = 'SET SEARCH_PATH TO prod, public' it's NOT a select statement: stmt=137182440 send_query(): conn=137151680, query='SET SEARCH_PATH TO prod, public' send_query: done sending query in QR_Constructor exit QR_Constructor read 6, global_socket_buffersize=4096 send_query: got id = 'C' send_query: ok - 'C' - SET send_query: setting cmdbuffer = 'SET' send_query: returning res = 137183504 send_query: got id = 'Z' PGAPI_ExecDirect: returned 0 from PGAPI_Execute CC_send_settings: result 0, status 1 from 'SET SEARCH_PATH TO prod, public' PGAPI_FreeStmt: entering...hstmt=137182440, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=137182440, self->result=0, self->hdbc=137151680 APD_free_params: ENTER, self=137182572 IPD_free_params: ENTER, self=137182600 IPD_free_params: EXIT SC_Destructor: EXIT CC_lookup_lo: entering... PGAPI_AllocStmt: entering... **** PGAPI_AllocStmt: hdbc = 137151680, stmt = 137177696 CC_add_statement: self=137151680, stmt=137177696 PGAPI_ExecDirect: entering... **** PGAPI_ExecDirect: hstmt=137177696, statement='select oid from pg_type where typname='lo'' PGAPI_ExecDirect: calling PGAPI_Execute... PGAPI_Execute: entering... PGAPI_Execute: clear errors... recycle statement: self= 137177696 Exec_with_parameters_resolved: 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=137177696, cursor_name='SQL_CUR0x82d2a60' send_query(): conn=137151680, 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 = 137183504 _next_tuple: 'C' fetch_total = 0 & this_fetch = 0 _next_tuple: 'C': DONE (fcount == 0) send_query: got id = 'Z' done sending the query: extend_column_bindings: entering ... self=137177776, bindings_allocated=0, num_columns=1 exit extend_column_bindings PGAPI_ExecDirect: returned 0 from PGAPI_Execute PGAPI_Fetch: stmt = 137177696, stmt->result= 137183504 manual_result = 0, use_declarefetch = 0 PGAPI_FreeStmt: entering...hstmt=137177696, fOption=1 QResult: in DESTRUCTOR QResult: free memory in, fcount=0 QResult: free memory out QResult: exit DESTRUCTOR SC_Destructor: self=137177696, self->result=0, self->hdbc=137151680 reset_a_column_binding: entering ... self=137177776, bindings_allocated=1, icol=1 APD_free_params: ENTER, self=137177828 IPD_free_params: ENTER, self=137177856 IPD_free_params: EXIT SC_Destructor: EXIT CC_lookup_characterset: entering... send_query(): conn=137151680, query='select pg_client_encoding()' send_query: done sending query in QR_Constructor exit QR_Constructor read 63, 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=64, 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=9, buffer='SQL_ASCII' end of tuple list -- setting inUse to false: this = 137183504 _next_tuple: 'C' fetch_total = 1 & this_fetch = 1 send_query: got id = 'Z' QResult: in DESTRUCTOR QResult: free memory in, fcount=1 row = 0, num_fields = 1 free [lf=0] 137183736 QResult: free memory out QResult: exit DESTRUCTOR CC_connect: returning... PGAPI_Connect: returning... [SQLGetFunctions]PGAPI_GetFunctions: entering...1 [SQLGetFunctions]PGAPI_GetFunctions: entering...2 [SQLGetFunctions]PGAPI_GetFunctions: entering...3 [SQLGetFunctions]PGAPI_GetFunctions: entering...4 [SQLGetFunctions]PGAPI_GetFunctions: entering...72 [SQLGetFunctions]PGAPI_GetFunctions: entering...55 [SQLGetFunctions]PGAPI_GetFunctions: entering...5 [SQLGetFunctions]PGAPI_GetFunctions: entering...6 [SQLGetFunctions]PGAPI_GetFunctions: entering...56 [SQLGetFunctions]PGAPI_GetFunctions: entering...40 [SQLGetFunctions]PGAPI_GetFunctions: entering...7 [SQLGetFunctions]PGAPI_GetFunctions: entering...57 [SQLGetFunctions]PGAPI_GetFunctions: entering...8 [SQLGetFunctions]PGAPI_GetFunctions: entering...58 [SQLGetFunctions]PGAPI_GetFunctions: entering...9 [SQLGetFunctions]PGAPI_GetFunctions: entering...41 [SQLGetFunctions]PGAPI_GetFunctions: entering...10 [SQLGetFunctions]PGAPI_GetFunctions: entering...11 [SQLGetFunctions]PGAPI_GetFunctions: entering...12 [SQLGetFunctions]PGAPI_GetFunctions: entering...59 [SQLGetFunctions]PGAPI_GetFunctions: entering...13 [SQLGetFunctions]PGAPI_GetFunctions: entering...60 [SQLGetFunctions]PGAPI_GetFunctions: entering...15 [SQLGetFunctions]PGAPI_GetFunctions: entering...16 [SQLGetFunctions]PGAPI_GetFunctions: entering...14 [SQLGetFunctions]PGAPI_GetFunctions: entering...42 [SQLGetFunctions]PGAPI_GetFunctions: entering...17 [SQLGetFunctions]PGAPI_GetFunctions: entering...43 [SQLGetFunctions]PGAPI_GetFunctions: entering...44 [SQLGetFunctions]PGAPI_GetFunctions: entering...45 [SQLGetFunctions]PGAPI_GetFunctions: entering...46 [SQLGetFunctions]PGAPI_GetFunctions: entering...47 [SQLGetFunctions]PGAPI_GetFunctions: entering...61 [SQLGetFunctions]PGAPI_GetFunctions: entering...62 [SQLGetFunctions]PGAPI_GetFunctions: entering...63 [SQLGetFunctions]PGAPI_GetFunctions: entering...18 [SQLGetFunctions]PGAPI_GetFunctions: entering...48 [SQLGetFunctions]PGAPI_GetFunctions: entering...64 [SQLGetFunctions]PGAPI_GetFunctions: entering...19 [SQLGetFunctions]PGAPI_GetFunctions: entering...65 [SQLGetFunctions]PGAPI_GetFunctions: entering...66 [SQLGetFunctions]PGAPI_GetFunctions: entering...67 [SQLGetFunctions]PGAPI_GetFunctions: entering...49 [SQLGetFunctions]PGAPI_GetFunctions: entering...20 [SQLGetFunctions]PGAPI_GetFunctions: entering...50 [SQLGetFunctions]PGAPI_GetFunctions: entering...21 [SQLGetFunctions]PGAPI_GetFunctions: entering...22 [SQLGetFunctions]PGAPI_GetFunctions: entering...68 [SQLGetFunctions]PGAPI_GetFunctions: entering...51 [SQLGetFunctions]PGAPI_GetFunctions: entering...52 [SQLGetFunctions]PGAPI_GetFunctions: entering...53 [SQLGetFunctions]PGAPI_GetFunctions: entering...70 [SQLGetFunctions]PGAPI_GetFunctions: entering...54 [SQLGetFunctions]PGAPI_GetFunctions: entering...23 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=77 PGAPI_GetInfo: p='02.50', len=0, value=0, cbMax=20 [SQLError]**** PGAPI_Error: henv=0, hdbc=137151680 hstmt=0 **** PGAPI_ConnectError: hdbc=137151680 <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 [SQLSetConnectionOption]PGAPI_SetConnectOption: entering fOption = 102 vParam = 1 PGAPI_SetConnectOption: AUTOCOMMIT: transact_status=0, vparam=1 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=77 PGAPI_GetInfo: p='02.50', len=0, value=0, cbMax=20 [SQLGetInfo]PGAPI_GetInfo: entering...fInfoType=17 PGAPI_GetInfo: p='PostgreSQL Legacy', len=0, value=0, cbMax=64 [SQLGetFunctions]PGAPI_GetFunctions: entering...61 [SQLGetFunctions]PGAPI_GetFunctions: entering...58 [SQLSetConnectionOption]PGAPI_SetConnectOption: entering fOption = 102 vParam = 1 [SQLGetConnectOption]PGAPI_GetConnectOption: entering... [SQLDisconnect]PGAPI_Disconnect: entering... PGAPI_Disconnect: about to CC_cleanup in CC_Cleanup, self=136983128 after CC_abort SOCK_Destructor