| Lists: | pgsql-general |
|---|
| 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 |
| 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: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Rob Sargent <rsargent(at)xmission(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: post installation addition of uuid extension |
| Date: | 2011-08-05 23:26:33 |
| Message-ID: | 11108.1312586793@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Rob Sargent <rsargent(at)xmission(dot)com> writes:
> 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
Considering that there are libossp-uuid RPMs in that repo, I'd bet good
money that the postgresql-contrib RPM contains contrib/uuid-ossp. Just
download that instead of building your own.
I'd imagine that pg_config is in the -devel RPM, FWIW.
regards, tom lane
| From: | Rob Sargent <rsargent(at)xmission(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: post installation addition of uuid extension |
| Date: | 2011-08-05 23:44:13 |
| Message-ID: | 4E3C804D.6090500@xmission.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On 08/05/2011 05:26 PM, Tom Lane wrote:
> Rob Sargent <rsargent(at)xmission(dot)com> writes:
>> 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
> Considering that there are libossp-uuid RPMs in that repo, I'd bet good
> money that the postgresql-contrib RPM contains contrib/uuid-ossp. Just
> download that instead of building your own.
>
> I'd imagine that pg_config is in the -devel RPM, FWIW.
>
> regards, tom lane
Thanks very much Tom.
I really must stop using a distro I don't like....
| From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: post installation addition of uuid extension |
| Date: | 2011-08-05 23:54:40 |
| Message-ID: | 4E3C82C0.3030504@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On 08/05/2011 05:26 PM, Tom Lane wrote:
> Rob Sargent <rsargent(at)xmission(dot)com> writes:
>> 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
> Considering that there are libossp-uuid RPMs in that repo, I'd bet good
> money that the postgresql-contrib RPM contains contrib/uuid-ossp. Just
> download that instead of building your own.
>
> I'd imagine that pg_config is in the -devel RPM, FWIW.
>
> regards, tom lane
>
Thanks very much Tom.
I really must stop using a distro I'm not fond of...
Cheers