invalid_cursor_state Invalid Cursor State — SQLSTATE 24000

The server reports SQLSTATE 24000 (invalid_cursor_state), a condition in the Invalid Cursor State class.

• The error is written to the server log and returned to the client carrying SQLSTATE 24000.
• Any driver (libpq, JDBC, psycopg, npgsql, pgx) surfaces this code in its error object so you can branch on it programmatically.
• PL/pgSQL can trap it by name: EXCEPTION WHEN invalid_cursor_state THEN.

Severity: ERROR  |  PostgreSQL versions: 12, 13, 14, 15, 16, 17

Reproduce with the exact statement and read the full message in the server log (raise log_min_messages / set log_min_error_statement for more context).

24000 belongs to Class 24 — Invalid Cursor State. In this class, a cursor was used in an invalid state.

The first two characters (24) identify the error class, so application code can match the whole class via 24000 when the specific code is not needed.

Declare/open the cursor before fetching, and do not fetch from a closed cursor; non-holdable cursors close at COMMIT.

Reference: PostgreSQL error codes — Class 24 (Invalid Cursor State).