это из psqlodbc_8120.log
[0.003]conn = 65C728C8, PGAPI_Connect(DSN='PostgreSQL30a', UID='SCOTT', PWD='xxxxx') [0.012]Driver Version='09.01.0100,201112290002' linking 1500 static Multithread library [0.020]Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [0.026] disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=0 [0.030] text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64 [0.035] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='' [0.321] [ PostgreSQL version string = '9.1.3' ] [0.322] [ PostgreSQL version number = '9.1' ] [0.340]conn=65C728C8, query='select oid, typbasetype from pg_type where typname = 'lo'' [0.360] [ fetched 0 rows ] [0.371] [ Large Object oid = -999 ] [0.374]conn=65C728C8, query='set client_encoding to 'WIN1251'' [0.482]conn=65C728C8, query='WITH RECURSIVE temp1 ( "empno","mgr","ename","job","hiredate","sal","comm","deptno",LEVEL ) AS (SELECT T1."empno",T1."mgr", T1."ename", T1."job",T1."hiredate", T1."sal",T1."comm",T1."deptno", 1 FROM EMP T1 WHERE T1."mgr" IS NULL union select T2."empno",T2."mgr", T2."ename", T2."job",T2."hiredate", T2."sal",T2."comm",T2."deptno",LEVEL + 1 FROM EMP T2 INNER JOIN temp1 ON( temp1."empno"= T2."mgr") )select * from temp1 ORDER BY LEVEL LIMIT 100' [0.623] [ fetched 14 rows ] [0.650]STATEMENT ERROR: func=PGAPI_ExtendedFetch, desc='', errnum=31, errmsg='The fetch type for PGAPI_ExtendedFetch isn't allowed with ForwardOnly cursor.' [0.656] ------------------------------------------------------------ [0.658] hdbc=65C728C8, stmt=65C77A28, result=65C78E70 [0.659] prepare=3, internal=0 [0.660] bindings=65C7FB60, bindings_allocated=9 [0.661] parameters=00000000, parameters_allocated=0 [0.662] statement_type=4, statement='WITH RECURSIVE temp1 ( "empno","mgr","ename","job","hiredate","sal","comm","deptno",LEVEL ) AS (SELECT T1."empno",T1."mgr", T1."ename", T1."job",T1."hiredate", T1."sal",T1."comm",T1."deptno", 1 FROM EMP T1 WHERE T1."mgr" IS NULL union select T2."empno",T2."mgr", T2."ename", T2."job",T2."hiredate", T2."sal",T2."comm",T2."deptno",LEVEL + 1 FROM EMP T2 INNER JOIN temp1 ON( temp1."empno"= T2."mgr") )select * from temp1 ORDER BY LEVEL LIMIT 100' [0.671] stmt_with_params='WITH RECURSIVE temp1 ( "empno","mgr","ename","job","hiredate","sal","comm","deptno",LEVEL ) AS (SELECT T1."empno",T1."mgr", T1."ename", T1."job",T1."hiredate", T1."sal",T1."comm",T1."deptno", 1 FROM EMP T1 WHERE T1."mgr" IS NULL union select T2."empno",T2."mgr", T2."ename", T2."job",T2."hiredate", T2."sal",T2."comm",T2."deptno",LEVEL + 1 FROM EMP T2 INNER JOIN temp1 ON( temp1."empno"= T2."mgr") )select * from temp1 ORDER BY LEVEL LIMIT 100' [0.680] data_at_exec=-1, current_exec_param=-1, put_data=0 [0.681] currTuple=-1, current_col=-1, lobj_fd=-1 [0.682] maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 [0.684] cursor_name='SQL_CUR65C77A28' [0.685] ----------------QResult Info ------------------------------- [0.686] fields=65C77A08, backend_tuples=65C790C8, tupleField=1707577544, conn=65C728C8 [0.688] fetch_count=0, num_total_rows=14, num_fields=9, cursor='(NULL)' [0.690] message='(NULL)', command='SELECT 14', notice='(NULL)' [0.691] status=100, inTuples=0 [0.692]CONN ERROR: func=PGAPI_ExtendedFetch, desc='', errnum=0, errmsg='(NULL)' [0.695] ------------------------------------------------------------ [0.696] henv=65C71280, conn=65C728C8, status=1, num_stmts=16 [0.698] sock=65C75430, stmts=65C77510, lobj_type=-999 [0.699] ---------------- Socket Info ------------------------------- [0.700] socket=600, reverse=0, errornumber=0, errormsg='(NULL)' [0.702] buffer_in=1707562240, buffer_out=1707566344 [0.703] buffer_filled_in=1425, buffer_filled_out=0, buffer_read_in=1425
а файл mylog_8120.log в аттаче
Вложения: |
Комментарий к файлу: mylog_8120.log
mylog_8120_log.txt [40.39 КБ]
Скачиваний: 763
|
|