[GENERAL] Make & Install contrib/tablefunc Problems

2010-06-10 Thread Stefan Schwarzer
Hi there, strange thing, but every time I need to (re)install the tablefunc, I run into problems. I am using the Kyngchaos packages for Snow Leopard. Everything works smoothly, until I arrive at the additional, manual installation of tablefunc. I downloaded the correct version of the postgres

Re: [GENERAL] Make & Install contrib/tablefunc Problems

2010-06-10 Thread Tom Lane
Stefan Schwarzer writes: > I downloaded the correct version of the postgres package (8.4.3), and > followed the indicated guidelines: > > You can build extensions for Postgres without fully rebuilding Postgres. For > the "contrib" extensions in

[GENERAL] Make & Install contrib/tablefunc Problems

2010-06-10 Thread Stefan Schwarzer
Hi there, strange thing, but every time I need to (re)install the tablefunc, I run into problems. I am using the Kyngchaos packages for Snow Leopard. Everything works smoothly, until I arrive at the additional, manual installation of tablefunc. I downloaded the correct version of the postgres

Re: [GENERAL] Make & Install contrib/tablefunc Problems

2010-01-26 Thread Tom Lane
Stefan Schwarzer writes: > 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 That's very curious.

Re: [GENERAL] Make & Install contrib/tablefunc Problems

2010-01-26 Thread Stefan Schwarzer
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: ./configu

Re: [GENERAL] Make & Install contrib/tablefunc Problems

2010-01-25 Thread Sam Mason
On Mon, Jan 25, 2010 at 04:05:57PM +0100, Stefan Schwarzer wrote: > Guess I'd need to do this as/with postgres user/role. Yup, or at least somebody with superuser rights. Try "\du" in psql. > But really not > sure how this goes. Thought it should be something like this: > > sudo su - po

Re: [GENERAL] Make & Install contrib/tablefunc Problems

2010-01-25 Thread Stefan Schwarzer
But when I do this I get this error message: Makefile:17: ../../src/Makefile.global: No such file or directory Makefile:18: /contrib/contrib-global.mk: No such file or directory make: *** No rule to make target `/contrib/contrib-global.mk'. Stop. What is the problem? What

Re: [GENERAL] Make & Install contrib/tablefunc Problems

2010-01-25 Thread Tom Lane
Stefan Schwarzer writes: > I deleted involuntarily my tablefunc functions in my database. Now, I > am trying to get them back into it again. But without success. > I am running Mac OS X, 10.5, with postgres 8.3.1 and have used the > Kyngchaos packages. It seems to me that before I succeeded i

[GENERAL] Make & Install contrib/tablefunc Problems

2010-01-25 Thread Stefan Schwarzer
Hi there, I deleted involuntarily my tablefunc functions in my database. Now, I am trying to get them back into it again. But without success. I am running Mac OS X, 10.5, with postgres 8.3.1 and have used the Kyngchaos packages. It seems to me that before I succeeded in doing this from w