From: Mindaugas Idzelis <mai3116@ritvax.isc.rit.edu>
To: pgsql-interfaces@postgresql.org
Subject: bug in ODBC driver (and fix)
Date: Fri, 19 Jan 2001 02:01:57 -0500
Message-ID: <JHELIEPMICHICPLGHHDKOEHHCAAA.mai3116@rit.edu> (raw)
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mai3116@ritvax.isc.rit.edu
Subject: Re: bug in ODBC driver (and fix)
In-Reply-To: <JHELIEPMICHICPLGHHDKOEHHCAAA.mai3116@rit.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox