| From: | Rob Sargent <rsargent(at)xmission(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | post installation addition of uuid extension |
| Date: | 2011-08-05 21:55:43 |
| Message-ID: | 4E3C66DF.5080907@xmission.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've inherited some version 9.0 databases which make use of the uuid
data type but which do not have the uuid-generate-vx() functions.
These installations are running on openSUSE 11.3 (x86_64) and were
installed (probably) from yast. I've loaded the requisite share-libs
(also via yast) (/usr/lib64/libossp-uuid.so.16 which does have an entry
point for uuid-export).
I have the source for 9.0.3 with the contrib/ossp-uuid package. But the
sql therein is of course uuid-ossp.sql.in and needs, I believe, to have
"'MODULE_PATHNAME'" resolved before it's useful.
Can anyone point me to the next step?
As a side note, pg_config was not installed and I don't see it as an
option in yast pointed at
http://download.opensuse.org/repositories/server:database:postgresql/openSUSE_11.3
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2011-08-05 22:34:50 | post installation addition of uuid extension |
| Previous Message | Jaime Casanova | 2011-08-05 18:42:57 | Re: postgres table have a large number of relpages and occupied a big memory size |