Skip site navigation (1) Skip section navigation (2)

bug report

From: "Giuliano A(dot) Tarallo" <aniello(at)tol(dot)it>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: bug report
Date: 1998-09-13 20:35:25
Message-ID: 35FC2C8C.87573134@tol.it (view raw or flat)
Thread:
Lists: 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 by date

Next:From: Mario AjzerleDate: 1998-09-13 23:55:43
Subject: Web server and database on different machines
Previous:From: Trever AdamsDate: 1998-09-11 21:42:19
Subject: Authentication etc.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group