[Solved] Why does this command fail?ALTER TEXT SEARCH CONFIGURATION english ADD MAPPING asciiword WITH simple; | PostgreSQL

PostgreSQL - Full-Text Search

Why does this command fail?

ALTER TEXT SEARCH CONFIGURATION english ADD MAPPING asciiword WITH simple;

ACannot alter built-in configurations directly

BMapping syntax is incorrect

CMissing semicolon at the end

DDictionary 'simple' does not exist

Step-by-Step Solution

Solution:

Step 1: Examine the ALTER syntax
The ADD MAPPING clause requires the FOR keyword: ADD MAPPING FOR token WITH dictionary.
Step 2: Rule out other issues
Built-in configurations can be altered (though not recommended), semicolon is present, and 'simple' dictionary exists.
Final Answer:
Mapping syntax is incorrect -> Option B
Quick Check:
ADD MAPPING requires FOR keyword [OK]

Quick Trick: ADD MAPPING syntax: FOR token WITH dict [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does this command fail?