[PostgreSQL] Make & Install contrib/tablefunc Problems

You need to re-run configure in the top level of the distribution tree.
Be sure to use the same configure flags as before (pg_config will remind
you what they were).

regards, tom lane

Thanks a lot for the quick reaction. Did this, but now - I am not
really strong in postgres management - I get this:

$ psql -U xxx my_database < tablefunc.sql
SET
ERROR: permission denied for language c

Guess I'd need to do this as/with postgres user/role. But really not
sure how this goes. Thought it should be something like this:

sudo su - postgres -c '/usr/local/pgsql/bin/pgsql' < tablefunc.sql

But that's no correct.

Thanks for any advice.

Looks about right, what do you get back?

The following does basically the same thing, but I find it a bit easier
to follow:

sudo -u postgres /usr/local/pgsql/bin/pgsql < tablefunc.sql

Thanks for that. Looks indeed less complicated! :-)

But not yet success for me:

I did re-start, just to be sure.

for postgres:
./configure (with parameters)
make

for tablefunc:
make
sudo make install

and then:
sudo -u postgres /usr/local/pgsql/bin/psql -d geodataportal < contrib/
tablefunc/tablefunc.sql
could not identify current directory: Permission denied
could not identify current directory: Permission denied
SET
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture
ERROR: relation "tablefunc_crosstab_2" already exists
ERROR: relation "tablefunc_crosstab_3" already exists
ERROR: relation "tablefunc_crosstab_4" already exists
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture
ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
found. Did find:
/usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong architecture

Besides the fact that I have no idea what is going on, if I look
through my database as indicated (-d geodataportal) I don't see any
"table_func" functions.

Thanks for any help.

That's very curious. Apparently you managed to build a .so of the wrong
machine architecture (ppc vs x86 vs x86_64). I would guess that you are
using somebody else's build of Postgres and didn't manage to duplicate
their configuration completely. Now, if it is somebody else's build,
they really should have provided the contrib modules too ... so why
didn't you just grab tablefunc from their distribution?

regards, tom lane