Re: odbc_fdw

Hi there!

I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in a
VMware under Win7).
I followed the steps in this guide:
www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from-source

It seems to work (I can run the server and connect to it with PgAdmin).

Now I'd like to integrate the ODBC_FDW extension in my installation.
Sadly, the make file throws errors (no target named "..." specified).
Is there any way to do this in a simple way?

I'm a linux newbie, by the way...

Thank you for your help!
Flo

On Sat, Nov 26, 2011 at 7:20 AM, Florian Schwendener <fschwend(at)hsr(dot)ch> wrote:
> Hi there!
>
> I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in a VMware
> under Win7).
> I followed the steps in this guide:
> www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from-source
>
> It seems to work (I can run the server and connect to it with PgAdmin).
>
> Now I'd like to integrate the ODBC_FDW extension in my installation. Sadly,
> the make file throws errors (no target named "..." specified).
> Is there any way to do this in a simple way?
>
> I'm a linux newbie, by the way...
>
> Thank you for your help!

You might want to try this question on pgsql-general or pgsql-novice
rather than here; this is a list for discussing the development of
PostgreSQL itself.

I think you'll find that no one can help you much based on the
information you've provided here; you'll need to say exactly what you
did and exactly what error message you got.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Hi Robert

2011/11/28 Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> You might want to try this question on pgsql-general or pgsql-novice
> rather than here; this is a list for discussing the development of
> PostgreSQL itself.

Thanks for the hint.

It was actually my advice to post this question here. A quick search
retrieves mostly (unanswered) postings which report problems compiling
the ODBC_FDW extension (e.g. [1]). My posting to psql-geneal is still
orphaned [2]?". Then I talked to some colleagues of the steering
committee of PGConf.DE recently and they confirmed that Foreign Data
Wrappers (FDW) probably are not stable.

So, I hope we finally find some FDW users and developpers over there
at pgsql-general :->

Yours, Stefan

[1] http://postgresql.1045698.n5.nabble.com/Problem-with-odbc-fdw-td4908875.html
[2] http://postgresql.1045698.n5.nabble.com/Integration-of-PostgresSQL-and-MongoDB-Any-Foreign-Data-Wrappers-SQL-MED-td4900771.html

2011/11/28 Robert Haas <robertmhaas(at)gmail(dot)com>:
> On Sat, Nov 26, 2011 at 7:20 AM, Florian Schwendener <fschwend(at)hsr(dot)ch> wrote:
>> Hi there!
>>
>> I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in a VMware
>> under Win7).
>> I followed the steps in this guide:
>> www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from-source
>>
>> It seems to work (I can run the server and connect to it with PgAdmin).
>>
>> Now I'd like to integrate the ODBC_FDW extension in my installation. Sadly,
>> the make file throws errors (no target named "..." specified).
>> Is there any way to do this in a simple way?
>>
>> I'm a linux newbie, by the way...
>>
>> Thank you for your help!
>
> You might want to try this question on pgsql-general or pgsql-novice
> rather than here; this is a list for discussing the development of
> PostgreSQL itself.
>
> I think you'll find that no one can help you much based on the
> information you've provided here; you'll need to say exactly what you
> did and exactly what error message you got.
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

After having read the most recent thread here about FDW [1] I still in
doubt what the status is of FDW in PostgreSQL 9.1. Looking at the
official docs of file_fdw as "Additional Supplied Module" [2] there's
no clue about SQL/MED and what the SQL syntax is. I'd like to
contribute at least to the documentation given there's any
implementation activity around FDWs.

Yours, Stefan

P.S. Sorry of not moving over to psql-general but I suspect that
there's support needed from developpers to make this nice stuff run.
[1] http://postgresql.1045698.n5.nabble.com/pgsql-fdw-FDW-for-PostgreSQL-server-td4935560.html[2]
http://www.postgresql.org/docs/9.1/interactive/file-fdw.html

2011/11/28 Stefan Keller <sfkeller(at)gmail(dot)com>:
> Hi Robert
>
> 2011/11/28 Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> You might want to try this question on pgsql-general or pgsql-novice
>> rather than here; this is a list for discussing the development of
>> PostgreSQL itself.
>
> Thanks for the hint.
>
> It was actually my advice to post this question here. A quick search
> retrieves mostly (unanswered) postings which report problems compiling
> the ODBC_FDW extension (e.g. [1]).  My posting to psql-general is still
> orphaned [2]?". Then I talked to some colleagues of the steering
> committee of PGConf.DE recently and they confirmed that Foreign Data
> Wrappers (FDW) probably are not stable.
>
> So, I hope we finally find some FDW users and developpers over there
> at pgsql-general  :->
>
> Yours, Stefan
>
> [1] http://postgresql.1045698.n5.nabble.com/Problem-with-odbc-fdw-td4908875.html
> [2] http://postgresql.1045698.n5.nabble.com/Integration-of-PostgresSQL-and-MongoDB-Any-Foreign-Data-Wrappers-SQL-MED-td4900771.html
>
>
> 2011/11/28 Robert Haas <robertmhaas(at)gmail(dot)com>:
>> On Sat, Nov 26, 2011 at 7:20 AM, Florian Schwendener <fschwend(at)hsr(dot)ch> wrote:
>>> Hi there!
>>>
>>> I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in a VMware
>>> under Win7).
>>> I followed the steps in this guide:
>>> www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from-source
>>>
>>> It seems to work (I can run the server and connect to it with PgAdmin).
>>>
>>> Now I'd like to integrate the ODBC_FDW extension in my installation. Sadly,
>>> the make file throws errors (no target named "..." specified).
>>> Is there any way to do this in a simple way?
>>>
>>> I'm a linux newbie, by the way...
>>>
>>> Thank you for your help!
>>
>> You might want to try this question on pgsql-general or pgsql-novice
>> rather than here; this is a list for discussing the development of
>> PostgreSQL itself.
>>
>> I think you'll find that no one can help you much based on the
>> information you've provided here; you'll need to say exactly what you
>> did and exactly what error message you got.
>>
>> --
>> Robert Haas
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>> --
>> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-hackers
>>

On Tue, Nov 29, 2011 at 3:32 AM, Stefan Keller <sfkeller(at)gmail(dot)com> wrote:
> After having read the most recent thread here about FDW [1] I still in
> doubt what the status is of FDW in PostgreSQL 9.1. Looking at the
> official docs of file_fdw as "Additional Supplied Module" [2] there's
> no clue about SQL/MED and what the SQL syntax is. I'd like to
> contribute at least to the documentation given there's any
> implementation activity around FDWs.

I certainly think it's possible that there may be some changes to the
FDW API for 9.2; indeed we've added a few things already (like options
on columns of foreign tables). I wouldn't expect to that to break
anything though. odbc_fdw is a third-party FDW that is not part of
the core distribution. It might be helpful to contact the author, but
if you want help here you at least need to provide some more details.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On 11/29/2011 10:13 AM, Robert Haas wrote:
> On Tue, Nov 29, 2011 at 3:32 AM, Stefan Keller<sfkeller(at)gmail(dot)com> wrote:
>> After having read the most recent thread here about FDW [1] I still in
>> doubt what the status is of FDW in PostgreSQL 9.1. Looking at the
>> official docs of file_fdw as "Additional Supplied Module" [2] there's
>> no clue about SQL/MED and what the SQL syntax is. I'd like to
>> contribute at least to the documentation given there's any
>> implementation activity around FDWs.
> I certainly think it's possible that there may be some changes to the
> FDW API for 9.2; indeed we've added a few things already (like options
> on columns of foreign tables). I wouldn't expect to that to break
> anything though. odbc_fdw is a third-party FDW that is not part of
> the core distribution. It might be helpful to contact the author, but
> if you want help here you at least need to provide some more details.

I think he has a point about the documentation, though. Perhaps an
"Advanced Features" section in the tutorial would be useful, if someone
wanted to contribute it. (Common Table Expressions would probably be
another suitable candidate for a tutorial section.)

cheers

andrew