>
> 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.
>
I installed with full optional modules on Windows, but uuid is still
missing. However, I found C:\Program
Files\PostgreSQL\8.3\share\contrib\uuid-ossp.sql, I run
Sabin Coanda wrote:
> I run the following script and now it works:
>
> CREATE OR REPLACE FUNCTION uuid_generate_v1()
> RETURNS uuid
> AS '$libdir/uuid-ossp', 'uuid_generate_v1'
> VOLATILE STRICT LANGUAGE C;
>
> Similar for all the other defined uuid functions.
There should be a uuid-ossp.sql fil
I run the following script and now it works:
CREATE OR REPLACE FUNCTION uuid_generate_v1()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_generate_v1'
VOLATILE STRICT LANGUAGE C;
Similar for all the other defined uuid functions.
Unfortunatelly I experienced the same problem on linux version 8.3.5. a
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_ge
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
LINE
