UUID in windows was Re: pgsql-general@postgresql.org.

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: grafl(at)datatrans(dot)hu
Cc: pgsql-general(at)postgresql(dot)org
Subject: UUID in windows was Re: pgsql-general@postgresql.org.
Date: 2008-08-03 21:24:13
Message-ID: dcc563d10808031424l11ae08d2t7460efc9d996d36d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pretty sure the uuid stuff only works in non-windows OSes.

Oh, and next time, use a more descriptive subject line for better /
quicker responses.

On Sun, Aug 3, 2008 at 2:18 PM, <grafl(at)datatrans(dot)hu> wrote:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Browse pgsql-general by date

  From Date Subject
Next Message Christophe 2008-08-03 21:34:24 Re: uuid
Previous Message grafl 2008-08-03 20:18:01 pgsql-general@postgresql.org.