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