Comment on A PostgreSQL Extension that allows you to access any other datasourceComments−leopard14yI try to install this extension on Ubuntu 11.10. First of all error in instalation -gcc -g -O2 -fPIC -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv -g -lpythonpython2: -fpic -L/usr/lib -Wl,-Bsymbolic-functions -Wl,--as-needed -Wl,--as-needed -Wl,--as-needed -lpythonpython2: -shared -o src/multicorn.so src/multicorn.o /usr/bin/ld: cannot find -lpythonpython2: /usr/bin/ld: cannot find -lpythonpython2: collect2: ld returned 1 exit status make: * [src/multicorn.so] Error 1 rm src/multicorn.o ERROR: command returned 2This is because Ubuntu have - python and python2.7 bin files. I fixed this by creating symlink on python.After instalation another problem:$ psql psql (9.1.1) Type "help" for help.leo=# CREATE EXTENSION multicorn; ERROR: could not load library "/usr/lib/postgresql/9.1/lib/multicorn.so": /usr/lib/postgresql/9.1/lib/multicorn.so: undefined symbol: _Py_NoneStructAll tested on specialy created for this system: $ python -V Python 2.7.2+ $ psql -V psql (PostgreSQL) 9.1.1 contains support for command-line editingOn this my tests end.−rdunklau14yThank you for this report. I'll try to make it work on Ubuntu, expect the documentation to be updated in the next few days.PS: if you're the 'leopard' who requested a redmine account, it should be activated now, feel free to report it there.−leopard14yOk, I already added this to tracker. I am very interesting in this extension, its amazing.
Comments
I try to install this extension on Ubuntu 11.10. First of all error in instalation -
gcc -g -O2 -fPIC -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv -g -lpythonpython2: -fpic -L/usr/lib -Wl,-Bsymbolic-functions -Wl,--as-needed -Wl,--as-needed -Wl,--as-needed -lpythonpython2: -shared -o src/multicorn.so src/multicorn.o /usr/bin/ld: cannot find -lpythonpython2: /usr/bin/ld: cannot find -lpythonpython2: collect2: ld returned 1 exit status make: * [src/multicorn.so] Error 1 rm src/multicorn.o ERROR: command returned 2
This is because Ubuntu have - python and python2.7 bin files. I fixed this by creating symlink on python.
After instalation another problem:
$ psql psql (9.1.1) Type "help" for help.
leo=# CREATE EXTENSION multicorn; ERROR: could not load library "/usr/lib/postgresql/9.1/lib/multicorn.so": /usr/lib/postgresql/9.1/lib/multicorn.so: undefined symbol: _Py_NoneStruct
All tested on specialy created for this system: $ python -V Python 2.7.2+ $ psql -V psql (PostgreSQL) 9.1.1 contains support for command-line editing
On this my tests end.
Thank you for this report. I'll try to make it work on Ubuntu, expect the documentation to be updated in the next few days.
PS: if you're the 'leopard' who requested a redmine account, it should be activated now, feel free to report it there.
Ok, I already added this to tracker. I am very interesting in this extension, its amazing.