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
