PostgreSQL Error Reference

Every error, explained

SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.

3804 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 3672 of 3804 errors

F0000 ERROR

unexpected end of line or lexeme — F0000

config_file_error

PostgreSQL error "unexpected end of line or lexeme" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

unexpected end of line — F0000

config_file_error

PostgreSQL error "unexpected end of line" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

too many lexemes in thesaurus entry — F0000

config_file_error

PostgreSQL error "too many lexemes in thesaurus entry" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

thesaurus sample word “…” isn’t recognized by subdictionary (rule n) — F0000

config_file_error

PostgreSQL error "thesaurus sample word "…" isn't recognized by subdictionary (rule n)" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

thesaurus substitute word “…” is a stop word (rule n) — F0000

config_file_error

PostgreSQL error "thesaurus substitute word "…" is a stop word (rule n)" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

thesaurus substitute word “…” isn’t recognized by subdictionary (ru… — F0000

config_file_error

PostgreSQL error "thesaurus substitute word "…" isn't recognized by subdictionary (rule n)" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

thesaurus substitute phrase is empty (rule n) — F0000

config_file_error

PostgreSQL error "thesaurus substitute phrase is empty (rule n)" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

invalid affix flag “…” — F0000

config_file_error

PostgreSQL error "invalid affix flag "…"" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

affix flag “…” is out of range — F0000

config_file_error

PostgreSQL error "affix flag "…" is out of range" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

invalid character in affix flag “…” — F0000

config_file_error

PostgreSQL error "invalid character in affix flag "…"" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

invalid affix flag “…” with “long” flag value — F0000

config_file_error

PostgreSQL error "invalid affix flag "…" with "long" flag value" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

could not open dictionary file “…”: the OS error — F0000

config_file_error

PostgreSQL error "could not open dictionary file "…": the OS error" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

invalid affix alias “…” — F0000

config_file_error

PostgreSQL error "invalid affix alias "…"" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

could not open affix file “…”: the OS error — F0000

config_file_error

PostgreSQL error "could not open affix file "…": the OS error" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

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

config_file_error

PostgreSQL error "Ispell dictionary supports only "default", "long", and "num" flag values" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

invalid number of flag vector aliases — F0000

config_file_error

PostgreSQL error "invalid number of flag vector aliases" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

number of aliases exceeds specified number n — F0000

config_file_error

PostgreSQL error "number of aliases exceeds specified number n" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

affix file contains both old-style and new-style commands — F0000

config_file_error

PostgreSQL error "affix file contains both old-style and new-style commands" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

could not open stop-word file “…”: the OS error — F0000

config_file_error

PostgreSQL error "could not open stop-word file "…": the OS error" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

could not parse contents of file “…” — F0000

config_file_error

PostgreSQL error "could not parse contents of file "…"" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

configuration file “…” contains errors — F0000

config_file_error

PostgreSQL error "configuration file "…" contains errors" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0001 ERROR

Lock File Exists — SQLSTATE F0001

lock_file_exists

SQLSTATE F0001 (lock_file_exists): A configuration file is invalid.

Configuration File Error
F0001 FATAL

lock file “…” already exists — F0001

lock_file_exists

PostgreSQL error "lock file "…" already exists" (SQLSTATE F0001): what it means, common causes, and how to fix it.

Configuration File Error
F0001 FATAL

lock file “…” is empty — F0001

lock_file_exists

PostgreSQL error "lock file "…" is empty" (SQLSTATE F0001, lock_file_exists): what it means, common causes, and how to fix it.

Configuration File Error