"Steve Shaffer" <sxs@coldmetal.com> writes:
> Pgsql v7.1 beta4
> ODBC v6.50.00.00
> RedHat v6.2
> I upgraded from 7.03 to 7.1 beta4 yesterday & see the following problem.
> After the upgrade, applications like Crystal Reports, MS Query, Brio, etc.
> now do not see the catalog of tables and fields in the database, login is
> through user postgres.
> SQL statements sent directly through the ODBC work correctly.
Guys, have you learned any more about this?
A useful investigation technique would be to turn on query logging at
the backend (eg, restart postmaster with -d2) so that you can see just
what queries are issued while these apps are trying to examine the
system catalogs.
regards, tom lane