no additional dynamic result sets returned

Category: No DataVersions: All Postgres versions

What this means

SQLSTATE 02001 indicates that a procedure or routine returned fewer dynamic result sets than the caller anticipated. The call completed but additional cursors or result sets were not produced.

Why it happens

1A SQL procedure returned fewer result sets than the calling context expected

How to reproduce

Caller requests more result sets than the procedure produces.

trigger — this will ERROR

WARNING: no additional dynamic result sets returned

Fix 1: Align caller expectations with the procedure definition

When this warning surfaces from a stored procedure call.

fix

Why this works

Review the procedure to confirm how many result sets it returns and update the calling code accordingly.

Sources

📚 Official docs: https://www.postgresql.org/docs/current/errcodes-appendix.html

🔧 Source ref: Class 02 — No Data

Confidence assessment

✅ HIGH confidence

Standard SQL code. Rarely seen in Postgres practice.