Thread: 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@hsr.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@gmail.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@gmail.com>: > On Sat, Nov 26, 2011 at 7:20 AM, Florian Schwendener <fschwend@hsr.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@postgresql.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@gmail.com>: > Hi Robert > > 2011/11/28 Robert Haas <robertmhaas@gmail.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@gmail.com>: >> On Sat, Nov 26, 2011 at 7:20 AM, Florian Schwendener <fschwend@hsr.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@postgresql.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@gmail.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@gmail.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