pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
7.1 Beta3 bug when using ODBC 2+ messages / 2 participants [nested] [flat]
* 7.1 Beta3 bug when using ODBC @ 2001-01-15 20:09 Knopp, Gary <gknopp@cereva.com> 2001-01-16 16:21 ` Re: 7.1 Beta3 bug when using ODBC Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Knopp, Gary @ 2001-01-15 20:09 UTC (permalink / raw) To: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 7.1 Beta3 bug when using ODBC 2001-01-15 20:09 7.1 Beta3 bug when using ODBC Knopp, Gary <gknopp@cereva.com> @ 2001-01-16 16:21 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2001-01-16 16:21 UTC (permalink / raw) To: Knopp, Gary <gknopp@cereva.com>; +Cc: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-01-16 16:21 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-01-15 20:09 7.1 Beta3 bug when using ODBC Knopp, Gary <gknopp@cereva.com> 2001-01-16 16:21 ` Tom Lane <tgl@sss.pgh.pa.us>
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