Sabin Coanda wrote: > Hi there, > > I installed Postgres "PostgreSQL 8.3.5, compiled by Visual C++ build 1400" > on Windows OS, and I tried to check some uuid functions, for instance: > SELECT uuid_generate_v1(); > > But I found the following error message: > ERROR: function uuid_generate_v1() does not exist
You'll want the uuid-ossp module: http://www.postgresql.org/docs/8.3/static/datatype-uuid.html http://www.postgresql.org/docs/8.3/static/uuid-ossp.html I *think* it's one of the optional modules with recent installers, but I don't run Windows routinely, so you'll have to check. -- Richard Huxton Archonet Ltd -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql