I try to install this extension on Ubuntu 11.10.
First of all error in instalation -<p>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: <i></i>* [src/multicorn.so] Error 1
rm src/multicorn.o
ERROR: command returned 2<p>This is because Ubuntu have - python and python2.7 bin files. I fixed this by creating symlink on python.<p>After instalation another problem:<p>$ psql
psql (9.1.1)
Type "help" for help.<p>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<p>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<p>On this my tests end.
I have well over 10K messages in gmail.<p>Will this work?<p>I was thinking in downloading the whole thing via POP3, creating a Unix mailbox and indexing that.
I was at OSCON Data this year that held a talk about the new foreign data connectors piece, it's great that Postgres has them now. Want twitter data? Make an interface to translate twitter data to rows, it's that easy! LucidDB has had foreign data connectors for a while but you have to use Java at least for part of it. I like the generator-style of yielding list-rows shown here: <a href="https://github.com/Kozea/Multicorn/blob/master/python/multicorn/csvfdw.py" rel="nofollow">https://github.com/Kozea/Multicorn/blob/master/python/multic...</a>