Date: Mon, 2 Oct 2000 16:36:02 +0100
From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: pgsql-interfaces@postgresql.org
Subject: PsqlODBC broken due to int4out(usesysid)
Message-ID: <20001002163602.H22505@quartz.newn.cam.ac.uk>
Reply-To: prlw1@cam.ac.uk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2i

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