ODBC + Access not working for Foreign Table (FDW)

From: Cedric Berger <cedric(at)precidata(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC + Access not working for Foreign Table (FDW)
Date: 2014-10-03 12:52:57
Message-ID: 542E9C29.5080306@precidata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Michael Paquier 2014-10-03 13:07:48 Re: ODBC + Access not working for Foreign Table (FDW)
Previous Message Oliver Freyd 2014-10-02 15:57:51 Strange issues with numeric type and an Access frontend