Re: BUG #3905: configure cannot find ossp UUID libs and/or includes

On Jan 28, 2008, at 13:52, Tom Lane wrote:

> Hmph ... works for me on a reasonably stock OS X 10.5.1 machine.
> You did do "make" and "make install" in the contrib subtree,
> right?

No. I assumed that that's what --with-ossp-uuid would do for me. But
yeah, that does work:

trigger# cd postgresql-8.3RC2/contrib/uuid-ossp
trigger# make
sed 's,MODULE_PATHNAME,$libdir/uuid-ossp,g' uuid-ossp.sql.in >uuid-
ossp.sql
gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing  -I. -I../../src/include -I/usr/local/include/libxml2  -I/usr/
local/include  -c -o uuid-ossp.o uuid-ossp.c
ar crs libuuid-ossp.a uuid-ossp.o
ranlib libuuid-ossp.a
gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing  -bundle -multiply_defined suppress  uuid-ossp.o  -L../../src/
port -L/usr/local/lib -L/usr/local/lib -luuid -bundle_loader ../../src/
backend/postgres  -o libuuid-ossp.0.0.so
rm -f libuuid-ossp.0.so
ln -s libuuid-ossp.0.0.so libuuid-ossp.0.so
rm -f libuuid-ossp.so
ln -s libuuid-ossp.0.0.so libuuid-ossp.so
trigger# make install
/bin/sh ../../config/install-sh -c -m 644 ./uninstall_uuid-ossp.sql '/
usr/local/pgsql/share/contrib'
/bin/sh ../../config/install-sh -c -m 644 uuid-ossp.sql '/usr/local/
pgsql/share/contrib'
/bin/sh ../../config/install-sh -c -m 755  libuuid-ossp.0.0.so '/usr/
local/pgsql/lib/uuid-ossp.so'
trigger# psql -U postgres /usr/local/pgsql/share/contrib/uuid-ossp.sql
postgres
psql: warning: extra command-line argument "postgres" ignored
psql: FATAL:  database "/usr/local/pgsql/share/contrib/uuid-ossp.sql"
does not exist
trigger# psql -U postgres -f /usr/local/pgsql/share/contrib/uuid-
ossp.sql postgres
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
trigger# psql -U postgres
trigger% psql
Welcome to psql 8.3RC2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
        \h for help with SQL commands
        \? for help with psql commands
        \g or terminate with semicolon to execute query
        \q to quit

david=# select uuid_generate_v1();
            uuid_generate_v1
--------------------------------------
  2bcce5e4-cdf0-11dc-b6a6-0017f2c2618f
(1 row)

Thanks,

David