Обсуждение: 7.1 Beta3 bug when using ODBC

Поиск
Список
Период
Сортировка

7.1 Beta3 bug when using ODBC

От
"Knopp, Gary"
Дата:
Hello,

If I try to create an ODBC link using a MSAccess or
Crystal Reports I'm unable to see any tables when I select my ODBC
postgres definition (ODBC postgres 6.5).  In the psqlodbc*.log it 
generate the following sql that returns no tables...

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

If I remove the int4out function and run the sql using psql everything
works fine.  Further examination of the int4out function shows that
what ever you send it, it returns the same value...

select int4out(2) from pg_class;
3374648

select int4out(1200) from pg_class;
3374648


Is anyone else experiencing the same problem



Re: 7.1 Beta3 bug when using ODBC

От
Tom Lane
Дата:
The bug is in the ODBC driver: it shouldn't be using int4out() in
the first place.  This has been fixed for awhile; please update
your ODBC driver.
        regards, tom lane