From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | eike(dot)send(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: gen_random_uuid is only available with pgcrypto enabled |
Date: | 2023-01-24 20:03:48 |
Message-ID: | CAKFQuwarXS0ygtxrr8RKJV2zyAM4ntnbd5opwEruWUOV=iBbbw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Tue, Jan 24, 2023 at 12:43 PM PG Doc comments form <
noreply(at)postgresql(dot)org> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/15/functions-uuid.html
> Description:
>
> Regarding the documentation on this page:
> https://www.postgresql.org/docs/15/functions-uuid.html
>
> It think the documentation should state clearly, that postgres natively
> does
> not have any UUID generation functions.
But that isn't true...
postgres=# select * from pg_extension;
oid | extname | extowner | extnamespace | extrelocatable | extversion |
extconfig | extcondition
-------+---------+----------+--------------+----------------+------------+-----------+--------------
12765 | plpgsql | 10 | 11 | f | 1.0 |
|
(1 row)
postgres=# select gen_random_uuid();
gen_random_uuid
--------------------------------------
0a1be850-b1ae-48b9-bfe1-038df1e227f7
(1 row)
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2023-01-24 20:21:23 | Re: Naming of network_ops vs. inet_ops for SP-GIST |
Previous Message | Tom Lane | 2023-01-24 20:03:37 | Re: gen_random_uuid is only available with pgcrypto enabled |