Thread: pgsql-general@postgresql.org.

Hi all,

I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following
the documentation I issued this query:

SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');

but the DB returns with this error message:

ERROR: function uuid_ns_url() does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might
need to add explicit type casts.
Character: 25

Any hint to use UUID within my database tirggers?

Thank you,
Laci

On Aug 3, 2008, at 1:18 PM, grafl@datatrans.hu wrote:
> ERROR: function uuid_ns_url() does not exist

Remember to install the functions in your database using the SQL file
in the contrib/uuid-ossp directory, uuid-ossp.sql.

Hi.

Sorry, it was not included in release.
please see,
http://winpg.jp/~saito/pg_work/OSSP_win32/

Regards,
Hiroshi Saito

>Hi all,
>
>I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following
>the documentation I issued this query:
>
>SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');
>
>but the DB returns with this error message:
>
>ERROR: function uuid_ns_url() does not exist
>SQL state: 42883
>Hint: No function matches the given name and argument types. You might
>need to add explicit type casts.
>Character: 25
>
>Any hint to use UUID within my database tirggers?
>
>Thank you,
>Laci
>
>
>--
>Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general

Hiroshi-san,

Is this something specific to windows? If so, should this be consider a bug?

Robert Treat

On Sunday 03 August 2008 18:01:05 Hiroshi Saito wrote:
> Hi.
>
> Sorry, it was not included in release.
> please see,
> http://winpg.jp/~saito/pg_work/OSSP_win32/
>
> Regards,
> Hiroshi Saito
>
> >Hi all,
> >
> >I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following
> >the documentation I issued this query:
> >
> >SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');
> >
> >but the DB returns with this error message:
> >
> >ERROR: function uuid_ns_url() does not exist
> >SQL state: 42883
> >Hint: No function matches the given name and argument types. You might
> >need to add explicit type casts.
> >Character: 25
> >
> >Any hint to use UUID within my database tirggers?
> >
> >Thank you,
> >Laci
> >
> >
> >--
> >Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> >To make changes to your subscription:
> >http://www.postgresql.org/mailpref/pgsql-general



--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Hi Robert-san

Ahh yes..
I'm sorry delaying release bugfix was not included in pg8.3.3.
Then,I will adjust next release(1.6.3/4) with Rarf-san again.

Regards,
Hiroshi Saito.

>Hiroshi-san,
>
>Is this something specific to windows? If so, should this be consider a bug?
>
>Robert Treat
>
>On Sunday 03 August 2008 18:01:05 Hiroshi Saito wrote:
>> Hi.
>>
>> Sorry, it was not included in release.
>> please see,
>> http://winpg.jp/~saito/pg_work/OSSP_win32/
>>
>> Regards,
>> Hiroshi Saito
>>
>> >Hi all,
>> >
>> >I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following
>> >the documentation I issued this query:
>> >
>> >SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');
>> >
>> >but the DB returns with this error message:
>> >
>> >ERROR: function uuid_ns_url() does not exist
>> >SQL state: 42883
>> >Hint: No function matches the given name and argument types. You might
>> >need to add explicit type casts.
>> >Character: 25
>> >
>> >Any hint to use UUID within my database tirggers?
>> >
>> >Thank you,
>> >Laci
>> >
>> >
>> >--
>> >Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> >To make changes to your subscription:
>> >http://www.postgresql.org/mailpref/pgsql-general
>
>
>
>--
>Robert Treat
>Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL