Hi everybody,
after some computing I found my psqlodbc filled with these errors (well,
after 10 minutes the psqlodbc log was more than 4 MB...):
CONN ERROR: func=PGAPI_ColAttributes, desc='', errnum=0, errmsg='(NULL)'
------------------------------------------------------------
henv=103876384, conn=103857648, status=1, num_stmts=16
sock=103876112, stmts=103876032, lobj_type=-999
---------------- Socket Info -------------------------------
socket=900, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=103868584, buffer_out=117047360
buffer_filled_in=264, buffer_filled_out=0, buffer_read_in=264
STATEMENT ERROR: func=PGAPI_ColAttributes, desc='', errnum=28,
errmsg='ColAttribute for this type not implemented yet'
------------------------------------------------------------
hdbc=103857648, stmt=103875360, result=103875808
manual_result=0, prepare=0, internal=0
bindings=103874672, bindings_allocated=4
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT * FROM "attributo" WHERE
"idFSV" =1171'
stmt_with_params='SELECT * FROM "attributo" WHERE "idFSV"
=1171'
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=0,
scroll_concurrency=1
cursor_name='SQL_CUR06310320'
----------------QResult Info -------------------------------
fields=103875776, manual_tuples=0, backend_tuples=117055568,
tupleField=117055568, conn=103857648
fetch_count=0, fcount=7, num_fields=4, cursor='(NULL)'
message='(NULL)', command='SELECT', notice='(NULL)'
status=8, inTuples=0
The "attributo" table is (from PgAdminII definition pane):
CREATE TABLE "attributo" (
"nome" varchar(30) NOT NULL,
"idFSV" int4 NOT NULL,
"tipo" int2 NOT NULL,
"id_enum" int4,
CONSTRAINT "attributo_pkey" PRIMARY KEY ("nome", "idFSV"),
CONSTRAINT "<unnamed>" FOREIGN KEY ("id_enum") REFERENCES "enumerazione"
("id_enum") ON DELETE CASCADE ON UPDATE NO ACTION NOT DEFERRABLE INITIALLY
IMMEDIATE,
CONSTRAINT "<unnamed>" FOREIGN KEY ("idFSV") REFERENCES "datoFSV" ("idFSV")
ON DELETE CASCADE ON UPDATE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE
);
Mmm.... what can I do to stop this flooding of errors? I think that this could
harm performance even when psqlodbc log is turned off, isn't it?
I'm using Postgres 7.1.3 and driver version 07.01.0011 (that's what
I read from the psqlodbc log, at least...).
Best regards
Andrea Aime
BTW: I see the same error on other tables, that are using the
same datatypes as "attributo"
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
|
