bug in ODBC driver (and fix)
От | Mindaugas Idzelis |
---|---|
Тема | bug in ODBC driver (and fix) |
Дата | |
Msg-id | JHELIEPMICHICPLGHHDKOEHHCAAA.mai3116@rit.edu обсуждение исходный текст |
Ответы |
Re: bug in ODBC driver (and fix)
|
Список | 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 по дате отправления: