42883 function PostgreSQL Origin: Data Last updated 12 Oct 2026

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.

Exact message you may see No function matches the given name and argument typesfunction does not existuuid_generate_v4() does not exist
Explore the map of this error Full error map →
Seen on: PostgreSQL

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

  1. Install the extension: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
  2. Cast arguments
  3. Use PostgreSQL equivalents (COALESCE, to_char)
  4. Use gen_random_uuid() (built-in since PG 13)

Detailed fix by platform

PostgreSQL

  1. SELECT gen_random_uuid();

How to diagnose

  1. Function — Name and argument types
  2. 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:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

ArgumentCountError — Fatal error: Uncaught ArgumentCountError: Too few arguments to function foo(), 1 passed and exactly 2 expected (PHP)ArgumentCountErrorCall to undefined function — PHP Fatal error: Uncaught Error: Call to undefined function (PHP)Call to undefined fun…could not find driver — PDOException: could not find driver (PHP)could not find drivercreate extension denied — ERROR: permission denied to create extension "x" — Must be superuser to create this extension. (PostgreSQL)create extension deni…extension not available — ERROR: could not open extension control file ".../postgis.control": No such file or directory (PostgreSQL)extension not availab…GD missing — Fatal error: Uncaught Error: Call to undefined function imagecreatefromjpeg() (PHP)GD missingintl missing — Class "NumberFormatter" not found / The "intl" PHP extension is required (PHP)intl missingITMS-90206 — ITMS-90206: Invalid Bundle. The bundle at 'App.appex' contains disallowed file 'Frameworks' (iOS)ITMS-9020642883 fun…

Explore the map of this error Full error map →

🧠 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.