pgadmin-org / pgadmin-org/pgadmin4

"Scripts" -> "Create Script" does not contain additional index parameters WITH, gist_trgm_ops(siglen)

Open
#9,625 2 comments 0 reactions 1 assignee View on GitHub

@RohitBhati8269 is already working on this.

Since Feb 26, 2026.

Bug
Dominant language
Python
Stars
3.8k
Forks
891
Avg merge
4d 7h
Merged PRs (30d)
8

Description

Describe the bug

I started playing with https://github.com/timescale/pg_textsearch extension. To create an index i used german dictionary WITH (text_config='german').
After clicking Create Script i do not see the additional parameter WITH (text_config='german');.

CREATE INDEX ON full_text_search USING bm25(content) WITH (text_config='german');

I wanted to export the table schema, so right-click on Tables -> full_text_search and select Scripts -> CREATE Script. I see the index script does not contain the additional parameter WITH (text_config='german');.

CREATE INDEX IF NOT EXISTS full_text_search_content_idx
    ON public.full_text_search USING bm25
    (content COLLATE pg_catalog."default")
    TABLESPACE pg_default;

Going to Tables -> full_text_search -> Indexes -> full_text_search_content_idx -> Create Script is exactly the same as before - no WITH (text_config='german');

I also created a GIST index with gist_trgm_ops(siglen=32) parameter

CREATE INDEX ON full_text_search USING GIST (content gist_trgm_ops(siglen=32));

Create Script does not show the additional gist_trgm_ops parameter (siglen=32).

CREATE INDEX IF NOT EXISTS full_text_search_content_idx1
    ON public.full_text_search USING gist
    (content COLLATE pg_catalog."default" gist_trgm_ops)
    WITH (fillfactor=90, buffering=auto)
    TABLESPACE pg_default;

To Reproduce

Steps to reproduce the behavior:

  1. Install pg_textsearch extension
  2. Run SQL commands
CREATE EXTENSION pg_textsearch;
CREATE TABLE full_text_search (
	id serial,
	content text
);
CREATE INDEX ON full_text_search USING bm25(content) WITH (text_config='german');
CREATE INDEX ON full_text_search USING GIST (content gist_trgm_ops(siglen=32));
  1. Go to Tables -> full_text_search and select Scripts -> CREATE Script.
    4.1. The additional parameter WITH (text_config='german') is missing
    4.2. The Additional parameter gist_trgm_ops (siglen=32) is missing

Expected behavior

In CREATE Script, I should see WITH (text_config='german') and gist_trgm_ops(siglen=32) parameter

In psql i see everything is fine:

test=# \d+ full_text_search
                                                        Table "public.full_text_search"
 Column  |  Type   | Collation | Nullable |                   Default                    | Storage  | Compression | Stats target | Description
---------+---------+-----------+----------+----------------------------------------------+----------+-------------+--------------+-------------
 id      | integer |           | not null | nextval('full_text_search_id_seq'::regclass) | plain    |             |              |
 content | text    |           |          |                                              | extended |             |              |
Indexes:
    "full_text_search_content_idx" bm25 (content) WITH (text_config=german)
    "full_text_search_content_idx1" gist (content gist_trgm_ops (siglen='32'))
Not-null constraints:
    "full_text_search_id_not_null" NOT NULL "id"
Access method: heap

pg_dump also shows everything fine

# pg_dump -Upostgres -t full_text_search --schema-only test
CREATE INDEX full_text_search_content_idx ON public.full_text_search USING bm25 (content) WITH (text_config=german);
CREATE INDEX full_text_search_content_idx1 ON public.full_text_search USING gist (content public.gist_trgm_ops (siglen='32'));

Error message

No error messages

Screenshots

Image

Desktop (please complete the following information):

  • OS: Windows 11 x64
  • pgAdmin 9.12
  • Mode: Desktop
  • Browser Google chrome
  • Package type: pgadmin4-9.12-x64.exe

Additional context

  • Is not related to the pg_textsearch extension - it's just something wrong during creating the index script
  • It is not related to dictionaries (I used german, italian etc.).
  • in GIST i tried different values of siglen - all the time, siglen is missing

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.