Обсуждение: Make & Install contrib/tablefunc Problems

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

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 the Postgres
source,just make sure the pgsql bin folder is in your path and define USE_PGXS before running make.  In a Terminal, cd
tothe extension source folder and: 

export PATH="/usr/local/pgsql/bin:$PATH"
export USE_PGXS=1
make
sudo make install

This will compile for your architecture, but only the 32bit version on Leopard (Snow builds 64bit by default).  If you
needto build 64bit (you can check Activity Monitor to see if Postgres is running 64bit), then add this export before
runningmake: 

export CUSTOM_COPT="-arch x86_64"
------------------------------------------------

But I get a :

$ sudo make install
Password:
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.

I get the same message when doing a "./configure" with the pg_config parameters.

Gush, what am I doing wrong? Thanks a lot for any hints,

Stef

Stefan Schwarzer <stefan.schwarzer@grid.unep.ch> 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 the
Postgressource, just make sure the pgsql bin folder is in your path and define USE_PGXS before running make.  In a
Terminal,cd to the extension source folder and: 

> export PATH="/usr/local/pgsql/bin:$PATH"
> export USE_PGXS=1
> make
> sudo make install

I believe those instructions are mistaken: make doesn't absorb variables
from the environment does it?  The "export PATH" is okay, but after it
do

    make USE_PGXS=1
    sudo make USE_PGXS=1 install

            regards, tom lane