The aim is to import a table from postgresql into M$ access using
PsqlODBC v06-50-0000. This is with
PostgreSQL 7.1devel on i386-unknown-netbsdelf1.5E, compiled by GCC egcs-1.1.2
source code of 14 August.
Problem: the pointy clicky box appears with no tables to select for import as
the driver sends:
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;
Reason: AFAICT it really doesn't want "int4out"..
select relname,usename,relhasrules
from pg_class,pg_user
where relkind = 'r'
and relname !~'^xinv[0-9]+'
and usesysid = relowner
order by relname;
works fine.. Can someone fix please?
Cheers,
Patrick