Ispell dictionary supports only “default”, “long”, and “num” flag v…

Symptoms

A statement failed with SQLSTATE F0000 (config_file_error), reported at severity ERROR. This is a Configuration File Error condition: PostgreSQL emits the message Ispell dictionary supports only "default", "long", and "num" flag values.

• The client receives SQLSTATE F0000 (config file error).
• The operation is rejected at ERROR level; the statement does not complete.

What the server log shows

ERROR:  Ispell dictionary supports only "default", "long", and "num" flag values

Why PostgreSQL raises this

Class F0 (Configuration File Error) is raised when a configuration file is malformed or a parameter value is invalid.

As described in PostgreSQL’s Section 19.1 Setting Parameters and Appendix A (PostgreSQL Error Codes), SQLSTATE F0000 carries the condition name config_file_error in class Configuration File Error. (Paraphrased — see the linked reference for the exact wording.)

Common causes

• A syntax error in postgresql.conf or an included file.
• An invalid or out-of-range parameter value.
• A parameter that cannot be set in the given context.

How to fix it

1. Fix the offending line and reload (pg_ctl reload).
2. Validate parameter values against the documented range.
3. Check the log for the exact file and line reported.

Version applicability

This message is present in PostgreSQL 15, 16, 17, 18 and 19.

Related & next steps

• SQLSTATE F0000 — Config File Error (full reference)
• PostgreSQL error code index

Reference: PostgreSQL Section 19.1 Setting Parameters.