ERROR: function x(text) does not exist — No function matches the given name and argument types
PostgreSQL found no function with that name and argument types — wrong types, missing extension, or schema not in search_path.
No function matches the given name and argument typesfunction does not existuuid_generate_v4() does not exist Meaning
Functions are overloaded by argument types. uuid_generate_v4() needs the uuid-ossp extension; MySQL functions (IFNULL, DATE_FORMAT) don’t exist in PostgreSQL.
Common causes
- Extension not installed (uuid-ossp, pgcrypto, postgis)
- Argument types don’t match any overload
- MySQL function names (IFNULL, NOW() variants, DATE_FORMAT)
- Function in a schema not on search_path
⚡ Quick fix
- Install the extension: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
- Cast arguments
- Use PostgreSQL equivalents (COALESCE, to_char)
- Use gen_random_uuid() (built-in since PG 13)
Detailed fix by platform
PostgreSQL
SELECT gen_random_uuid();
How to diagnose
- Function — Name and argument types
- Extension — Installed in this database?
🔧 Still not fixed?
Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:
Similar errors
Most viewed in PostgreSQL
- prepared statement exists ERROR: prepared statement "s1" already exists (PgBouncer transaction mode)
- incompatible data directory FATAL: database files are incompatible with server — The data directory was initialized by PostgreSQL version 15, which is not compatible with this version 16
- 23505 PostgreSQL: ERROR: duplicate key value violates unique constraint
Other ways to find it
Where this error sits
Origin: Data. Errors that are often confused with or caused by this one (click to open):
🧠 Still stuck? Analyze your error
Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.
💬 What worked for others
No tips yet — did something else fix this for you?
Share what worked for you
Tips are checked by an editor before they appear. Links are removed.
Report a correction or suggest an improvement
Last updated 12 Oct 2026