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