Обсуждение: ODBC + Access not working for Foreign Table (FDW)

Hello,

Having just tested my first FDW, I tried to access my foreign
tables with MS Access 2000 using the latest MS ODBC driver.

Unfortunately, I just found that foreign tables are not listed
when you do " Get External Data => Link Tables": Only Views
and Regular tables are shown.

I could workaround the problem by defining a view:

   CREATE VIEW workaround AS SELECT * FROM foreign_table.

But it sucks, and I don't know if there are performance drops
going through a view like that.

I glanced at the ODBC sources, and my guess is that inside
info.c, lines like:

     strcat(tables_query, " where relkind in ('r', 'v')");

should be modified to add the 'f' type.

Is that correct?
Could someone have a look at that?

right now, I can test a MSI, but I've never compiled ODBC myself.

Cedric

On 03/10/14 15:07, Michael Paquier wrote:

> On Fri, Oct 3, 2014 at 9:52 PM, Cedric Berger <cedric@precidata.com
> <mailto:cedric@precidata.com>> wrote:
>
>           strcat(tables_query, " where relkind in ('r', 'v')");
>     should be modified to add the 'f' type.
>     Is that correct?
>
> Close enough, there are a couple of extra things to consider though.
>
>     Could someone have a look at that?
>
> Well, this has been raised not so long ago, resulting in the submission
> of a not-so-beautiful patch I have to say :)
> http://www.postgresql.org/message-id/CAB7nPqR0apHpiPAi4J2e3oR2jZ8MREyJAzxdWMjrr4h5PsRp4w@mail.gmail.com

Cool!

So what is the process here?

Is there something I can do to help that code (or sth similar)
getting checked in?

Thanks,
Cedric