Error message

bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist

nested exception is org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist

 

It is caused by the absence of the uuid_generate_v4 function.

The reason for this problem is that the uuid function uuid_generate_v4() is in the Postgresql extension by default. After the database is migrated, the extension extension is gone and needs to be reinstalled.

 

 

Solution:
Execute in sql query

CREATE EXTENSION pgcrypto;

Can

In addition, adding uuid support to PG only needs to run in sql

create extension "uuid-ossp"

Test function:

select uuid_generate_v4()

Similar Posts:

• Python: How to get the MAC Address
• C++ write and read file via fstream in ios::out,ios::in,ios::app mode
• How to solve the problem of adding copied disk in cannot register the hard disk of VirtualBox
• How to solve the problem of potentially unsupported type in Python sqllite
• C write and read file via FILE and open method in a+ or r mode
• Openstack build virtual machine Error: No valid host was found. There are not enough hosts available
• PostgreSQL Connect Error: FATAL: no pg_hba.conf entry for host
• A start job is running for dev disk by when Ubuntu starts
• [Solved] Ubuntu Startup Errors were found while checking the disk-drive for /
• Greenplum Error: query plan with multiple segworker groups is not supported