conn=28914224, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1 DSN info: DSN='PostgreSQL',server='thorbecke',port='5432',dbase='jeroen',user='postgres',passwd='postgres' readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0' conn_settings='' translation_dll='',translation_option='' Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190 disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=1 text_as_longvarchar=0, unknowns_as_longvarchar=0, bools_as_char=1 extra_systable_prefixes='dd_;', conn_settings='' conn=28914224, query=' ' conn=28914224, query='set DateStyle to 'ISO'' conn=28914224, query='set ksqo to 'ON'' conn=28914224, query='BEGIN' conn=28914224, query='declare SQL_CUR01BA0040 cursor for select oid from pg_type where typname='lo'' conn=28914224, query='fetch 100 in SQL_CUR01BA0040' [ fetched 0 rows ] conn=28914224, query='close SQL_CUR01BA0040' conn=28914224, query='END' conn=28914224, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=jeroen;SERVER=thorbecke;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=' conn=28914224, query='BEGIN' conn=28914224, query='declare SQL_CUR01BA0040 cursor for SELECT Config, nValue FROM MSysConf' ERROR from backend during send_query: 'ERROR: msysconf: Table does not exist.' conn=28914224, query='ABORT' STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query' ------------------------------------------------------------ hdbc=28914224, stmt=28966976, result=0 manual_result=0, prepare=0, internal=0 bindings=0, bindings_allocated=0 parameters=0, parameters_allocated=0 statement_type=0, statement='SELECT Config, nValue FROM MSysConf' stmt_with_params='declare SQL_CUR01BA0040 cursor for SELECT Config, nValue FROM MSysConf' data_at_exec=-1, current_exec_param=-1, put_data=0 currTuple=-1, current_col=-1, lobj_fd=-1 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 cursor_name='SQL_CUR01BA0040' ----------------QResult Info ------------------------------- CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: msysconf: Table does not exist.' ------------------------------------------------------------ henv=28914208, conn=28914224, status=1, num_stmts=16 sock=28920560, stmts=28928816, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=352, reverse=0, errornumber=0, errormsg='(null)' buffer_in=28920608, buffer_out=28924712 buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2 conn=28914224, query='BEGIN' conn=28914224, query='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))' ERROR from backend during send_query: 'ERROR: Unable to locate type name 'lo' in catalog' conn=28914224, query='COMMIT' STATEMENT ERROR: func=SC_execute, desc='', errnum=17, errmsg='Error creating the table' ------------------------------------------------------------ hdbc=28914224, stmt=28966976, result=0 manual_result=0, prepare=0, internal=0 bindings=0, bindings_allocated=0 parameters=0, parameters_allocated=0 statement_type=4, statement='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))' stmt_with_params='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))' data_at_exec=-1, current_exec_param=-1, put_data=0 currTuple=-1, current_col=-1, lobj_fd=-1 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 cursor_name='SQL_CUR01BA0040' ----------------QResult Info ------------------------------- CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: Unable to locate type name 'lo' in catalog' ------------------------------------------------------------ henv=28914208, conn=28914224, status=1, num_stmts=16 sock=28920560, stmts=28928816, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=352, reverse=0, errornumber=0, errormsg='(null)' buffer_in=28920608, buffer_out=28924712 buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2 conn=29101184, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1 DSN info: DSN='PostgreSQL',server='thorbecke',port='5432',dbase='jeroen',user='postgres',passwd='postgres' readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0' conn_settings='' translation_dll='',translation_option='' Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190 disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=1 text_as_longvarchar=0, unknowns_as_longvarchar=0, bools_as_char=1 extra_systable_prefixes='dd_;', conn_settings='' conn=29101184, query=' ' conn=29101184, query='set DateStyle to 'ISO'' conn=29101184, query='set ksqo to 'ON'' conn=29101184, query='BEGIN' conn=29101184, query='declare SQL_CUR01BA0040 cursor for select oid from pg_type where typname='lo'' conn=29101184, query='fetch 100 in SQL_CUR01BA0040' [ fetched 0 rows ] conn=29101184, query='close SQL_CUR01BA0040' conn=29101184, query='END' conn=29101184, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=jeroen;SERVER=thorbecke;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=' conn=29101184, query='BEGIN' conn=29101184, query='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))' ERROR from backend during send_query: 'ERROR: Unable to locate type name 'lo' in catalog' conn=29101184, query='COMMIT' STATEMENT ERROR: func=SC_execute, desc='', errnum=17, errmsg='Error creating the table' ------------------------------------------------------------ hdbc=29101184, stmt=28966976, result=0 manual_result=0, prepare=0, internal=0 bindings=0, bindings_allocated=0 parameters=0, parameters_allocated=0 statement_type=4, statement='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))' stmt_with_params='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))' data_at_exec=-1, current_exec_param=-1, put_data=0 currTuple=-1, current_col=-1, lobj_fd=-1 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 cursor_name='SQL_CUR01BA0040' ----------------QResult Info ------------------------------- CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: Unable to locate type name 'lo' in catalog' ------------------------------------------------------------ henv=28914208, conn=29101184, status=1, num_stmts=16 sock=28930496, stmts=28931080, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=428, reverse=0, errornumber=0, errormsg='(null)' buffer_in=28932416, buffer_out=28936520 buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2 conn=29101184, SQLDisconnect conn=28914224, SQLDisconnect