modifying_sql_data_not_permitted Modifying Sql Data Not Permitted — SQLSTATE 2F002

The server reports SQLSTATE 2F002 (modifying_sql_data_not_permitted), a condition in the SQL Routine Exception class.

• The error is written to the server log and returned to the client carrying SQLSTATE 2F002.
• 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 modifying_sql_data_not_permitted 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).

2F002 belongs to Class 2F — SQL Routine Exception. In this class, an SQL function raised an error.

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

Inspect the function body, its argument handling, and any SQL it runs; the failure originates inside the routine.

Reference: PostgreSQL error codes — Class 2F (SQL Routine Exception).