bug in ODBC driver (and fix) - Mailing list pgsql-interfaces

From Mindaugas Idzelis
Subject bug in ODBC driver (and fix)
Date
Msg-id JHELIEPMICHICPLGHHDKOEHHCAAA.mai3116@rit.edu
Whole thread Raw
Responses Re: bug in ODBC driver (and fix)
List pgsql-interfaces
I can't show any tables using the ODBC driver. There is something wrong with
the query it uses to select the tables. The query it is using is:

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

and it should be:

select relname, usename, relhasrules from pg_class, pg_user where relkind =
'r' and relname !~ '^pg_|^dd_' and relname !~ '^xinv[0-9]+' and usesysid =
relowner order by relname

the int4out() function should be removed. I am using version 6.5 of the ODBC
driver. Is there a patch that makes this work? Thank you.

The 1 line change should be done in the file info.c.
(please reply to my email address mai3116@rit.edu as i am not a mailing list
subscriber)



pgsql-interfaces by date:

Previous
From: Tibor Laszlo
Date:
Subject: Re: pl/pgSQL & transaction
Next
From: Steve Sullivan
Date:
Subject: JDBC gives pq_recvbuf: unexpected EOF on client connection