conn=47331544, SQLDriverConnect( in)='DRIVER={PostgreSQL ODBC+ Driver};UID=nbadmin;CONNSETTINGS=;SHOWSYSTEMTABLES=0;ROWVERSIONING=0;SHOWOIDCOLUMN=0;FAKEOIDINDEX=0;PROTOCOL=6.4;READONLY=0;PORT=5432;SERVER=dorag;DATABASE=js_portland;', nDriverCompletion=3 Global Options: Version='01.00.00', fetch=300, socket=4096, unknown_sizes=0, max_varchar_size=8190, max_longvarchar_size=8190 disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=1 text_as_longvarchar=0, unknowns_as_longvarchar=0, bools_as_char=1 extra_systable_prefixes='pg_;', conn_settings='' conn=47331544, query=' ' conn=47331544, query='set DateStyle to 'ISO'' conn=47331544, query='set geqo to 'OFF'' conn=47331544, query='set ksqo to 'ON'' conn=47331544, query='BEGIN' conn=47331544, query='declare SQL_CUR02D27230 cursor for select oid from pg_type where typname='lo'' conn=47331544, query='fetch 300 in SQL_CUR02D27230' [ fetched 0 rows ] conn=47331544, query='close SQL_CUR02D27230' conn=47331544, query='END' conn=47331544, query='BEGIN' conn=47331544, query='declare SQL_CUR02D27230 cursor for select version()' conn=47331544, query='fetch 300 in SQL_CUR02D27230' [ fetched 1 rows ] [ PostgreSQL version string = 'PostgreSQL 7.2b2 on i686-pc-linux-gnu, compiled by GCC 2.96' ] [ PostgreSQL version number = '7.2' ] conn=47331544, query='close SQL_CUR02D27230' conn=47331544, query='END' conn=47331544, SQLDriverConnect(out)='DRIVER={PostgreSQL ODBC+ Driver};DATABASE=js_portland;SERVER=dorag;PORT=5432;UID=nbadmin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=' conn=47331544, query='BEGIN' conn=47331544, query='declare SQL_CUR02D29E50 cursor for select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname !~ '^pg_|^pg_' and usesysid = relowner order by relname' conn=47331544, query='fetch 300 in SQL_CUR02D29E50' [ fetched 66 rows ] conn=47331544, query='close SQL_CUR02D29E50' conn=47331544, query='END' conn=47331544, query='BEGIN' conn=47331544, query='declare SQL_CUR02D27230 cursor for SELECT evtime, evtime::timetz::time, gpsfix FROM positions WHERE job_seq = 35 and job_tag = '69'' conn=47331544, query='fetch 300 in SQL_CUR02D27230' [ fetched 51 rows ] conn=47331544, query='declare SQL_CUR02E41EE8 cursor for select u.usename, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules from pg_user u, pg_class c, pg_attribute a, pg_type t where u.usesysid = c.relowner and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'positions' order by attnum' conn=47331544, query='fetch 300 in SQL_CUR02E41EE8' [ fetched 14 rows ] SQLColumns: table='positions',field_name='rev',type=23,sqltype=47027984,name='int4' SQLColumns: table='positions',field_name='evtime',type=1184,sqltype=47027984,name='timestamptz' SQLColumns: table='positions',field_name='bus_tag',type=25,sqltype=47027984,name='text' SQLColumns: table='positions',field_name='gpstime',type=1184,sqltype=47027984,name='timestamptz' SQLColumns: table='positions',field_name='gpsfix',type=600,sqltype=47027984,name='point' SQLColumns: table='positions',field_name='gpsspeed',type=700,sqltype=47027984,name='float4' SQLColumns: table='positions',field_name='gpsheading',type=700,sqltype=47027984,name='float4' SQLColumns: table='positions',field_name='job_tag',type=25,sqltype=47027984,name='text' SQLColumns: table='positions',field_name='schedclass_tag',type=25,sqltype=47027984,name='text' SQLColumns: table='positions',field_name='srv_class',type=25,sqltype=47027984,name='text' SQLColumns: table='positions',field_name='job_seq',type=23,sqltype=47027984,name='int4' SQLColumns: table='positions',field_name='path_pos',type=700,sqltype=47027984,name='float4' SQLColumns: table='positions',field_name='source',type=25,sqltype=47027984,name='text' SQLColumns: table='positions',field_name='at_stop',type=16,sqltype=47027984,name='bool' conn=47331544, query='close SQL_CUR02E41EE8' conn=47331544, query='declare SQL_CUR02D2BA78 cursor for SELECT evtime, evtime::timetz::time, gpsfix FROM positions WHERE job_seq = 35 and job_tag = '69'' conn=47331544, query='fetch 300 in SQL_CUR02D2BA78' [ fetched 51 rows ] conn=47331544, query='close SQL_CUR02D2BA78' conn=47331544, query='close SQL_CUR02D27230' conn=47331544, query='END' conn=47331544, SQLDisconnect