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

bug in ODBC driver (and fix)

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 (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-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)


Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2001-01-19 15:44:41
Subject: Re: bug in ODBC driver (and fix)
Previous:From: The Hermit HackerDate: 2001-01-19 02:39:11
Subject: Test post ...

pgsql-interfaces by date

Next:From: Peter T MountDate: 2001-01-19 08:55:53
Subject: Re: [PATCHES] Re: Fixes and enhancements to JDBC driver (take 2)
Previous:From: The Hermit HackerDate: 2001-01-19 01:28:23
Subject: pgsql-interfaces mailing list branches ...

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