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
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 |