postgres uuid_ generate_ v1() does not exist

Catalog

One 、 The phenomenon ：

Two 、 reason ：

3、 ... and 、 resolvent ：

1. install uuid-ossp Extended dependency environment

2. Enable uuid-ossp Expand

3. verification

Re execution

---

One 、 The phenomenon ：

schema=# select uuid_generate_v1();

ERROR: function uuid_generate_v1() does not exist

 The first 1 That's ok select uuid_generate_v1();

^

 Tips : No function matches the given name and argument types. You might need to add explicit type casts.

 Time ：14.543 ms

Two 、 reason ：

By default ,postgres It's not uuid_generate_v1 Methodical , You need to install extensions , And enable it uuid-ossp Before you can use this method .

3、 ... and 、 resolvent ：

1. install uuid-ossp Extended dependency environment

You can use compilation or installation Yum install , Because my environment here is Postgres10,yum install , So... Is preferred yum Install the extension .

yum install -y postgresql10-contrib

2. Enable uuid-ossp Expand

postgres=# create extension "uuid-ossp" ;

CREATE EXTENSION

3. verification

postgres-# \dx

 List of installed extensions 

 name  |  edition  |  Architecture mode  |  describe 

-----------+------+------------+-------------------------------------------------

plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language

uuid-ossp | 1.1 | public | generate universally unique identifiers (UUIDs)

More details

postgres=# \dx+
         Object is used to extend  "plpgsql"
                Object description                 
---------------------------------------
  function  plpgsql_call_handler()
  function  plpgsql_inline_handler(internal)
  function  plpgsql_validator(oid)
  Language  plpgsql
(4  rows )

      Object is used to extend  "uuid-ossp"
              Object description              
----------------------------------
  function  uuid_generate_v1()
  function  uuid_generate_v1mc()
  function  uuid_generate_v3(uuid,text)
  function  uuid_generate_v4()
  function  uuid_generate_v5(uuid,text)
  function  uuid_nil()
  function  uuid_ns_dns()
  function  uuid_ns_oid()
  function  uuid_ns_url()
  function  uuid_ns_x500()
(10  rows )

Re execution

postgres=# select uuid_generate_v1();
           uuid_generate_v1           
--------------------------------------
 9ffd8cc8-db44-11eb-8952-0050568a41b8
(1  rows )