Re: Make & Install contrib/tablefunc Problems

[Stefan Schwarzer <stefan.schwarzer@xxxxxxxxxxxx>]

> 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.

<<attachment: smime.p7s>>