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
Show quoted text
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: 25Any 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
Import Notes
Resolved by subject fallback
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 SaitoHi 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: 25Any 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.
Show quoted text
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 SaitoHi 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: 25Any 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
Import Notes
Resolved by subject fallback