[0.005]conn=010E4308, PGAPI_DriverConnect( in)='DSN=PostgreSQL30W;', fDriverCompletion=3 [0.008]DSN info: DSN='PostgreSQL30W',server='192.168.1.107',port='5432',dbase='SEE',user='glyn',passwd='xxxxx' [0.008] onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0' [0.009] conn_settings='',conn_encoding='(null)' [0.009] translation_dll='',translation_option='' [0.011]Driver Version='08.03.0100,200801220001' linking 1400 static Multithread library [0.011]Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [0.012] disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0 [0.012] text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64 [0.012] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='' [0.021] [ PostgreSQL version string = '8.2.5' ] [0.021] [ PostgreSQL version number = '8.2' ] [0.024]conn=010E4308, query='select oid, typbasetype from pg_type where typname = 'lo'' [0.028] [ fetched 0 rows ] [0.030] [ Large Object oid = -999 ] [0.030] [ Client encoding = 'UTF8' (code = 6) ] [0.031]conn=010E4308, PGAPI_DriverConnect(out)='DSN=PostgreSQL30W;DATABASE=SEE;SERVER=192.168.1.107;PORT=5432;UID=glyn;PWD=xxxxxxxx;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1b50fbb;A1=7.4-1' [12.167]conn=010E4308, query='select * from "Events"."PRICE" limit 1;' [12.200] [ fetched 1 rows ] [12.241]conn=010E4308, query='select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 29767065) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum' [12.341] [ fetched 50 rows ] [12.374]PGAPI_Columns: table='PRICE',field_name='RECNUM',type=20,name='int8' [12.391]PGAPI_Columns: table='PRICE',field_name='SHOW',type=1700,name='numeric' [12.409]PGAPI_Columns: table='PRICE',field_name='TPRICE',type=1700,name='numeric' [12.426]PGAPI_Columns: table='PRICE',field_name='CPRICE',type=1700,name='numeric' [12.444]PGAPI_Columns: table='PRICE',field_name='CREDLOAD',type=1700,name='numeric' [12.460]PGAPI_Columns: table='PRICE',field_name='QPURCH',type=1700,name='numeric' [12.478]PGAPI_Columns: table='PRICE',field_name='QSOLD',type=1700,name='numeric' [12.495]PGAPI_Columns: table='PRICE',field_name='QSOR',type=1700,name='numeric' [12.512]PGAPI_Columns: table='PRICE',field_name='STATUS',type=1700,name='numeric' [12.531]PGAPI_Columns: table='PRICE',field_name='SELL_TO',type=1700,name='numeric' [12.548]PGAPI_Columns: table='PRICE',field_name='POSTAGE',type=1700,name='numeric' [12.565]PGAPI_Columns: table='PRICE',field_name='NARR',type=1043,name='varchar' [12.582]PGAPI_Columns: table='PRICE',field_name='MAX_SELL',type=1700,name='numeric' [12.600]PGAPI_Columns: table='PRICE',field_name='TYPE',type=1700,name='numeric' [12.618]PGAPI_Columns: table='PRICE',field_name='SOLD7',type=1700,name='numeric' [12.635]PGAPI_Columns: table='PRICE',field_name='SOLD14',type=1700,name='numeric' [12.653]PGAPI_Columns: table='PRICE',field_name='MEDIA_LOAD',type=1700,name='numeric' [12.670]PGAPI_Columns: table='PRICE',field_name='SOURCE1',type=1700,name='numeric' [12.688]PGAPI_Columns: table='PRICE',field_name='SOURCE2',type=1700,name='numeric' [12.706]PGAPI_Columns: table='PRICE',field_name='PRINTED',type=1700,name='numeric' [12.724]PGAPI_Columns: table='PRICE',field_name='PROM_LOAD',type=1700,name='numeric' [12.742]PGAPI_Columns: table='PRICE',field_name='INFO1',type=1043,name='varchar' [12.759]PGAPI_Columns: table='PRICE',field_name='INFO2',type=1043,name='varchar' [12.777]PGAPI_Columns: table='PRICE',field_name='INFO3',type=1043,name='varchar' [12.794]PGAPI_Columns: table='PRICE',field_name='INFO4',type=1043,name='varchar' [12.812]PGAPI_Columns: table='PRICE',field_name='INFO5',type=1043,name='varchar' [12.831]PGAPI_Columns: table='PRICE',field_name='LOGGED_IN',type=1700,name='numeric' [12.848]PGAPI_Columns: table='PRICE',field_name='SEATED',type=1043,name='varchar' [12.867]PGAPI_Columns: table='PRICE',field_name='TICKETS_IN',type=1700,name='numeric' [12.884]PGAPI_Columns: table='PRICE',field_name='TICKETS_PR',type=1700,name='numeric' [12.904]PGAPI_Columns: table='PRICE',field_name='HOW_MANY',type=1700,name='numeric' [12.922]PGAPI_Columns: table='PRICE',field_name='FREE_AMOUNT',type=1700,name='numeric' [12.940]PGAPI_Columns: table='PRICE',field_name='RANGE_FROM',type=1700,name='numeric' [12.957]PGAPI_Columns: table='PRICE',field_name='RANGE_TO',type=1700,name='numeric' [12.974]PGAPI_Columns: table='PRICE',field_name='SPARE',type=1700,name='numeric' [12.993]PGAPI_Columns: table='PRICE',field_name='SPAREA',type=1043,name='varchar' [13.011]PGAPI_Columns: table='PRICE',field_name='OFFER',type=1700,name='numeric' [13.028]PGAPI_Columns: table='PRICE',field_name='DATE_1',type=1082,name='date' [13.045]PGAPI_Columns: table='PRICE',field_name='DATE_2',type=1082,name='date' [13.062]PGAPI_Columns: table='PRICE',field_name='INT_1',type=1700,name='numeric' [13.079]PGAPI_Columns: table='PRICE',field_name='INT_2',type=1700,name='numeric' [13.095]PGAPI_Columns: table='PRICE',field_name='INT_3',type=1700,name='numeric' [13.114]PGAPI_Columns: table='PRICE',field_name='INT_4',type=1700,name='numeric' [13.132]PGAPI_Columns: table='PRICE',field_name='INT_5',type=1700,name='numeric' [13.151]PGAPI_Columns: table='PRICE',field_name='STRING_1',type=1043,name='varchar' [13.169]PGAPI_Columns: table='PRICE',field_name='STRING_2',type=1043,name='varchar' [13.187]PGAPI_Columns: table='PRICE',field_name='RESERVED',type=1700,name='numeric' [13.205]PGAPI_Columns: table='PRICE',field_name='INT_6',type=1700,name='numeric' [13.222]PGAPI_Columns: table='PRICE',field_name='INT_7',type=1700,name='numeric' [13.241]PGAPI_Columns: table='PRICE',field_name='STRING_3',type=1043,name='varchar' [57.405]conn=010E4308, query='select * from "Events"."PRICE" limit 1' [57.438] [ fetched 1 rows ]