search

Segfault-Inc / Multicorn

Data Access Library
https://multicorn.org/
PostgreSQL License
700 stars 145 forks source link

No module named alchemyfdw #32

Closed pparsniak closed 10 years ago

pparsniak commented 10 years ago

CREATE SERVER mssql foreign data wrapper multicorn options ( wrapper 'multicorn.alchemyfdw.SqlAlchemyFdw' );

BŁĄD: Error in python: ImportError DETAIL: No module named alchemyfdw \ Błąd **

BŁĄD: Error in python: ImportError Stan SQL: XX000

Szczegóły: No module named alchemyfdw

Am I missing something? how to get rid of this error?

paradoxxxzero commented 10 years ago

There's no module named multicorn.alchemyfdw, (look into the python directory). Maybe try multicorn.sqlalchemyfdw.SqlAlchemyFdw.

pparsniak commented 10 years ago

Yes, you're right. There is module sqlalchemyfdw, but i've copied that from documentation manual, so there is an error in example code:

CREATE SERVER alchemy_srv foreign data wrapper multicorn options ( wrapper 'multicorn.alchemyfdw.SqlAlchemyFdw' );

create foreign table mysql_table ( column1 integer, column2 varchar ) server alchemy_srv options ( tablename 'table', db_url 'mysql://myuser:mypassword@myhost/mydb' );

Can somebody write tutorial with examples how get this to work with mssql? I've created an foregin server and foregin table, but when I execute any query my postgresql server drops connection to my pgadmin.

What modules and packages shoud I install to make it work and how to configure them? when I tried to use server connection string from documentation example: "mssql: mssql://user>:<password>@<dsname" it didn't work.

Please write howto with examples for those, who do not know python language and "wrapper modules"