PsqlODBC broken due to int4out(usesysid)

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: PsqlODBC broken due to int4out(usesysid)
Date: 2000-10-02 15:36:02
Message-ID: 20001002163602.H22505@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2000-10-02 17:10:47 Re: PsqlODBC broken due to int4out(usesysid)
Previous Message Patrick Welche 2000-10-02 15:13:54 Re: Asking for the [conninfo] definition