EC
54023
PostgreSQLERRORNotableProgram Limit ExceededHIGH confidence

too many arguments

What this means

SQLSTATE 54023 is raised when a function call passes more arguments than Postgres supports. The maximum number of function arguments is 100.

Why it happens
  1. 1A function call with more than 100 arguments
  2. 2A generated SQL function call with too many parameters
How to reproduce

Function call with more than 100 arguments.

expected output

ERROR:  functions cannot have more than 100 arguments

Fix

Refactor the function to accept arrays or a composite type

WHEN When many values must be passed to a function.

Refactor the function to accept arrays or a composite type
-- Instead of f(a1, a2, ..., a100), use:
CREATE FUNCTION process_batch(items TEXT[]) RETURNS VOID AS $
-- process items
$ LANGUAGE plpgsql;

SELECT process_batch(ARRAY['a','b','c',...]);

Why this works

Passing an array or a composite type allows an arbitrary number of values to be passed as a single argument, bypassing the 100-argument limit.

Sources
Official documentation ↗

Class 54 — Program Limit Exceeded

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All PostgreSQL errors