there are still issues

Can you please give information on which Postgres version you are using there?

And, sorry for asking since you most likely did, but: Did you reindex again?

last test was made on postgresql 12.4 & php 7.4.13
...anyway the postgresql version doesn't really matter, i'm afraid..

i'll recommend you to review #30412 ?

Did you reindex again?

i've tested with the Prebuilt package + sample data, and yes i've reindexed

I've reworked the PR and it should be working now. Please test.

This should now fix

1. Indexing of content in Postgres
2. Search in frontend in Postgres and
3. Suggestions for Postgres

I have tested this item ✅ successfully on 298b78c

with postgresql 11.7

@Hackwar In the description you wrote:

This is the second attempt after #31782

I guess you meant #31787 .

I have tested this item ✅ successfully on 298b78c

Suggestions work now on PosgreSQL as well as on MySQL.

There is a problem with suggestions not being shown when the search string starts with a capital letter.

But that's common for MySQL and PostgreSQL and so not related to this PR here.

There is PR #33940 to fix that for J4, but it should be fixed for J3, too, I think.

I have tested this item ✅ successfully on 298b78c

Suggestions work now on PosgreSQL as well as on MySQL.

There is a problem with suggestions not being shown when the search string starts with a capital letter.

But that's common for MySQL and PostgreSQL and so not related to this PR here.

There is PR #33940 to fix that for J4, but it should be fixed for J3, too, I think.

RTC

Thanks