Skip to content

Instantly share code, notes, and snippets.

@onderkalaci

onderkalaci/text_search_config_errors.sql

Created April 11, 2022 13:32
Show Gist options
  • Save onderkalaci/e1572b8806b330f32a20f85bac15fc69 to your computer and use it in GitHub Desktop.
Save onderkalaci/e1572b8806b330f32a20f85bac15fc69 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
text_search_config_errors.sql
-- weird error
CREATE TEXT SEARCH CONFIGURATION en ( parser = default );
ALTER TEXT SEARCH CONFIGURATION en ALTER MAPPING FOR host, host WITH simple;
ERROR: duplicate key value violates unique constraint "pg_ts_config_map_index"
DETAIL: Key (mapcfg, maptokentype, mapseqno)=(25798, 6, 1) already exists.
-- same error, sometimes we get "ERROR: tuple already updated by self"
CREATE TEXT SEARCH CONFIGURATION dutch ( copy = dutch );
ALTER TEXT SEARCH CONFIGURATION dutch ADD MAPPING FOR host WITH simple;
ERROR: duplicate key value violates unique constraint "pg_ts_config_map_index"
DETAIL: Key (mapcfg, maptokentype, mapseqno)=(25798, 6, 1) already exists.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment