PsqlODBC broken due to int4out(usesysid)

Поиск
Список
Период
Сортировка
От Patrick Welche
Тема PsqlODBC broken due to int4out(usesysid)
Дата
Msg-id 20001002163602.H22505@quartz.newn.cam.ac.uk
обсуждение исходный текст
Ответы Re: PsqlODBC broken due to int4out(usesysid)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-interfaces
The aim is to import a table from postgresql into M$ access using
PsqlODBC v06-50-0000. This is withPostgreSQL 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,relhasrulesfrom pg_class,pg_userwhere 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,relhasrulesfrom pg_class,pg_userwhere relkind = 'r'and relname !~'^xinv[0-9]+'and usesysid =
relownerorderby relname;
 

works fine.. Can someone fix please?

Cheers,

Patrick


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Patrick Welche
Дата:
Сообщение: Re: Asking for the [conninfo] definition
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PsqlODBC broken due to int4out(usesysid)