conn=40581336, SQLDriverConnect( in)='DSN=PostgreSQL;', nDriverCompletion=1 DSN info: DSN='PostgreSQL',server='',port='5432',dbase='',user='',passwd='' onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0' conn_settings='' translation_dll='',translation_option='' 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=40581336, query=' ' conn=40581336, query='set DateStyle to 'ISO'' conn=40581336, query='set geqo to 'OFF'' conn=40581336, query='set ksqo to 'ON'' conn=40581336, query='BEGIN' conn=40581336, query='declare SQL_CUR026B7230 cursor for select oid from pg_type where typname='lo'' conn=40581336, query='fetch 300 in SQL_CUR026B7230' [ fetched 0 rows ] conn=40581336, query='close SQL_CUR026B7230' conn=40581336, query='END' conn=40581336, query='BEGIN' conn=40581336, query='declare SQL_CUR026B7230 cursor for select version()' conn=40581336, query='fetch 300 in SQL_CUR026B7230' [ 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=40581336, query='close SQL_CUR026B7230' conn=40581336, query='END' conn=40581336, SQLDriverConnect(out)='DSN=PostgreSQL;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=40581336, query='BEGIN' conn=40581336, query='declare SQL_CUR026B9D88 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=40581336, query='fetch 300 in SQL_CUR026B9D88' [ fetched 66 rows ] conn=40581336, query='close SQL_CUR026B9D88' conn=40581336, query='END' conn=40581336, query='BEGIN' conn=40581336, query='declare SQL_CUR026B7230 cursor for SELECT evtime, evtime::timetz::time, gpsfix FROM positions WHERE job_seq = 35 and job_tag = '69'' conn=40581336, query='fetch 300 in SQL_CUR026B7230' [ fetched 51 rows ] conn=40581336, query='declare SQL_CUR02C016B8 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=40581336, query='fetch 300 in SQL_CUR02C016B8' [ fetched 14 rows ] SQLColumns: table='positions',field_name='rev',type=23,sqltype=40277776,name='int4' SQLColumns: table='positions',field_name='evtime',type=1184,sqltype=40277776,name='timestamptz' SQLColumns: table='positions',field_name='bus_tag',type=25,sqltype=40277776,name='text' SQLColumns: table='positions',field_name='gpstime',type=1184,sqltype=40277776,name='timestamptz' SQLColumns: table='positions',field_name='gpsfix',type=600,sqltype=40277776,name='point' SQLColumns: table='positions',field_name='gpsspeed',type=700,sqltype=40277776,name='float4' SQLColumns: table='positions',field_name='gpsheading',type=700,sqltype=40277776,name='float4' SQLColumns: table='positions',field_name='job_tag',type=25,sqltype=40277776,name='text' SQLColumns: table='positions',field_name='schedclass_tag',type=25,sqltype=40277776,name='text' SQLColumns: table='positions',field_name='srv_class',type=25,sqltype=40277776,name='text' SQLColumns: table='positions',field_name='job_seq',type=23,sqltype=40277776,name='int4' SQLColumns: table='positions',field_name='path_pos',type=700,sqltype=40277776,name='float4' SQLColumns: table='positions',field_name='source',type=25,sqltype=40277776,name='text' SQLColumns: table='positions',field_name='at_stop',type=16,sqltype=40277776,name='bool' conn=40581336, query='close SQL_CUR02C016B8' conn=40581336, query='close SQL_CUR026B7230' conn=40581336, query='END' conn=40581336, SQLDisconnect