Foreign tables using postgresql_fdw or odbc_fdw

From: "Edson Carlos Ericksson Richter" <richter(at)simkorp(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Foreign tables using postgresql_fdw or odbc_fdw
Date: 2011-09-18 13:32:43
Message-ID: 000901cc7607$760af520$6220df60$@com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tried both, but they don't work for 9.1.

I want to thank Adrian, without his help I would never find the link that
confirmed the postgresql_fdw is not working.

Would be nice to make all this information clear in Foreign Data Wrapper
documentation at PostgreSQL manuals.

I wasted at least 12 hours trying to make it work. The only real option is
file_fdw, that is not that useful (I would connect my database to files just
for curiosity - otherwise, I would use only an application that validates
the file before importing into database for fast operations).

odbc_fdw would work, but it's near to impossible for a normal human bean to
compile using MSVC; and it's not available in binary format (see, I'm not a
C developer for many, many years now... and I work in an hybrid environment
with Windows and Linux machines).

Sorry for the rant... I hope to save time for others who wish to use FDW in
a real scenario.

Regards,

Edson Richter.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jimmy K. 2011-09-18 17:06:00 Re: Alternative JDBC driver
Previous Message Mike Christensen 2011-09-18 04:22:15 Clean way to insert records if they don't exist, update if they do