From: | Mindaugas Idzelis <mai3116(at)ritvax(dot)isc(dot)rit(dot)edu> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | bug in ODBC driver (and fix) |
Date: | 2001-01-19 07:01:57 |
Message-ID: | JHELIEPMICHICPLGHHDKOEHHCAAA.mai3116@rit.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-odbc |
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(at)rit(dot)edu as i am not a mailing list
subscriber)
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 2001-01-19 08:55:53 | Re: [PATCHES] Re: Fixes and enhancements to JDBC driver (take 2) |
Previous Message | The Hermit Hacker | 2001-01-19 01:28:23 | pgsql-interfaces mailing list branches ... |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-19 15:44:41 | Re: bug in ODBC driver (and fix) |
Previous Message | The Hermit Hacker | 2001-01-19 02:39:11 | Test post ... |