bug report
От | Giuliano A. Tarallo |
---|---|
Тема | bug report |
Дата | |
Msg-id | 35FC2C8C.87573134@tol.it обсуждение исходный текст |
Список | pgsql-interfaces |
Hello The error documented in the next log appear when I try to use pg as a ODBC Generic SQL Server with a commercial application developed with Microsoft C++ thanks Giuliano A. psqlodbc.log DSN info: DSN='PostgreSQL',server='gat',port='5432',dbase='mydb',user='udrl',passwd='qwerty' readonly='0',protocol='',showoid='1',fakeoidindex='1',showsystable='0' conn_settings='' translation_dll='',translation_option='' conn = 33357944, SQLConnect(DSN='PostgreSQL', UID='udrl', PWD='qwerty') Global Options: fetch=100, socket=4096, unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=4094 disable_optimizer=1, unique_index=1, use_declarefetch=0 text_as_longvarchar=0, unknowns_as_longvarchar=0, bools_as_char=1 extra_systable_prefixes='dd_;', conn_settings='' conn=33357944, query=' ' conn=33357944, query='set DateStyle to 'ISO'' conn=33357944, query='set geqo to 'OFF'' conn=33357944, query='select oid from pg_type where typname='lo'' [ fetched 0 rows ] conn=33357944, query='select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^pg_|^dd_' and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner) order by relname' [ fetched 0 rows ] conn=33357944, query='BEGIN' conn=33357944, query='CREATE TABLE MovAgeR (IDMovAge int4,Riga int2,Agente char(8),ImpBase float8,ImpProvv float8,DtaPrevMat datetime,DtaEffMat datetime,Sospesa char(1),GiaAutoFtt char(1),GiaFttAge char(1),Storna char(1),Nota char(64))' conn=33357944, query='COMMIT' conn=33357944, query='select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'MovAgeR' order by attnum' [ fetched 0 rows ] conn=33357944, query='select distinct on attnum a2.attname, a2.attnum from pg_attribute a1, pg_attribute a2, pg_class c, pg_index i where c.relname = 'MovAgeR_pkey' AND c.oid = i.indexrelid AND a1.attrelid = c.oid AND a2.attrelid = c.oid AND (i.indkey[0] = a1.attnum OR i.indkey[1] = a1.attnum OR i.indkey[2] = a1.attnum OR i.indkey[3] = a1.attnum OR i.indkey[4] = a1.attnum OR i.indkey[5] = a1.attnum OR i.indkey[6] = a1.attnum OR i.indkey[7] = a1.attnum) order by a2.attnum' [ fetched 0 rows ] STATEMENT ERROR: func=SQLFetch, desc='', errnum=3, errmsg='Null statement result in SQLFetch.' ------------------------------------------------------------ hdbc=33357944, stmt=33372436, result=0 manual_result=1, prepare=0, internal=0 bindings=33438208, bindings_allocated=6 parameters=0, parameters_allocated=0 statement_type=-2, statement='(null)' stmt_with_params='' 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=3, scroll_concurrency=1 cursor_name='' ----------------QResult Info ------------------------------- CONN ERROR: func=SQLFetch, desc='', errnum=0, errmsg='' ------------------------------------------------------------ henv=34410316, conn=33357944, status=1, num_stmts=16 sock=34410332, stmts=34410372, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=36, reverse=0, errornumber=0, errormsg='(null)' buffer_in=33364236, buffer_out=33368336 buffer_filled_in=45, buffer_filled_out=0, buffer_read_in=45 conn=33357944, query='BEGIN' conn=33357944, query='CREATE UNIQUE INDEX Idx1 ON MovAgeR (IDMovAge,Riga)' conn=33357944, query='COMMIT' conn=33357944, query='BEGIN' conn=33357944, query='CREATE INDEX Idx2 ON MovAgeR (Agente,DtaEffMat)' conn=33357944, query='COMMIT' conn=33357944, query='BEGIN' conn=33357944, query='CREATE INDEX Idx3 ON MovAgeR (DtaEffMat,Agente,GiaAutoFtt,GiaFttAge)' conn=33357944, query='COMMIT' conn=33357944, query='BEGIN' conn=33357944, query='CREATE TABLE CodParlRadiceStato (RadiceCodParl char(21),ISOStato char(2),Descri char(32),Prezzo float8,Nota char(64))' conn=33357944, query='COMMIT' conn=33357944, query='select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'CodParlRadiceStato' order by attnum' [ fetched 0 rows ] conn=33357944, query='select distinct on attnum a2.attname, a2.attnum from pg_attribute a1, pg_attribute a2, pg_class c, pg_index i where c.relname = 'CodParlRadiceStato_pkey' AND c.oid = i.indexrelid AND a1.attrelid = c.oid AND a2.attrelid = c.oid AND (i.indkey[0] = a1.attnum OR i.indkey[1] = a1.attnum OR i.indkey[2] = a1.attnum OR i.indkey[3] = a1.attnum OR i.indkey[4] = a1.attnum OR i.indkey[5] = a1.attnum OR i.indkey[6] = a1.attnum OR i.indkey[7] = a1.attnum) order by a2.attnum' [ fetched 0 rows ] STATEMENT ERROR: func=SQLFetch, desc='', errnum=3, errmsg='Null statement result in SQLFetch.' ------------------------------------------------------------ hdbc=33357944, stmt=33372436, result=0 manual_result=1, prepare=0, internal=0 bindings=33438620, bindings_allocated=6 parameters=0, parameters_allocated=0 statement_type=-2, statement='(null)' stmt_with_params='' 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=3, scroll_concurrency=1 cursor_name='' ----------------QResult Info ------------------------------- CONN ERROR: func=SQLFetch, desc='', errnum=0, errmsg='' ------------------------------------------------------------ henv=34410316, conn=33357944, status=1, num_stmts=16 sock=34410332, stmts=34410372, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=36, reverse=0, errornumber=0, errormsg='(null)' buffer_in=33364236, buffer_out=33368336 buffer_filled_in=45, buffer_filled_out=0, buffer_read_in=45 conn=33357944, query='BEGIN' conn=33357944, query='CREATE UNIQUE INDEX Idx1 ON CodParlRadiceStato (RadiceCodParl,ISOStato)' ERROR from backend during send_query: 'ERROR: Cannot create index: 'idx1' already exists' conn=33357944, query='COMMIT' STATEMENT ERROR: func=SC_execute, desc='', errnum=17, errmsg='Error creating the table' ------------------------------------------------------------ hdbc=33357944, stmt=33372436, result=0 manual_result=0, prepare=0, internal=0 bindings=0, bindings_allocated=0 parameters=0, parameters_allocated=0 statement_type=4, statement='CREATE UNIQUE INDEX Idx1 ON CodParlRadiceStato (RadiceCodParl,ISOStato)' stmt_with_params='CREATE UNIQUE INDEX Idx1 ON CodParlRadiceStato (RadiceCodParl,ISOStato)' 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=3, scroll_concurrency=1 cursor_name='SQL_CUR33372436' ----------------QResult Info ------------------------------- CONN ERROR: func=SC_execute, desc='', errnum=10, errmsg='ERROR: Cannot create index: 'idx1' already exists' ------------------------------------------------------------ henv=34410316, conn=33357944, status=1, num_stmts=16 sock=34410332, stmts=34410372, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=36, reverse=0, errornumber=0, errormsg='(null)' buffer_in=33364236, buffer_out=33368336 buffer_filled_in=2, buffer_filled_out=0, buffer_read_in=2 parameters=0, parameters_allocated=0 statement_type=-2, statement='(null)' stmt_with_params='' data_at_exec=-1, current_exec_param=-1, put_data=0 currTuple=-1, current_col=-1, lobj_fd=-1 thanks Giuliano A.
В списке pgsql-interfaces по дате отправления: