Timeline for 'text search dictionary "unaccent" does not exist' entries in postgres log, supposedly during automatic analyze
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 10, 2018 at 12:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 31, 2018 at 21:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 1, 2018 at 6:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 13, 2018 at 8:25 | history | edited | Erwin Brandstetter |
tag
|
|
| Aug 13, 2018 at 8:18 | comment | added | Erwin Brandstetter |
Actually, you can change the function definition with CREATE OR REPLACE FUNCTION ... without rebuilding anything. Expression indexes rely on the immutability of the used function and are not stopping you. If you make sure that the function keeps using the same function & dictionary, indexes keep working properly. (You can't DROP the function, though.)
|
|
| Aug 13, 2018 at 8:09 | comment | added | P.Péter | Schema-qualifying need application-side change which I am not sure I can make. Also, it needs a complete database rebuild using the new unaccent function. I may try it later, but not in the very near future. The security measure does not really apply to me, as I have a single database with a single user and access control is all in the application, so it is more annoying than useful to me; it would be nice to be able to turn it off. | |
| Aug 13, 2018 at 7:43 | comment | added | Erwin Brandstetter |
The search_path for autovacuum has been changed for security reasons. I don't expect them to revert that change nor to offer users the unsafe option to do so. Have you tried to schema-qualify function and dictionary as suggested?
|
|
| Aug 13, 2018 at 7:19 | comment | added | P.Péter | No, I do not. I would like add the public schema to the autovacuum search_path if I knew how to do that, but I found nothing in the documentation to that effect (just that they removed it from there, but no way to put it back, I would not like to downgrade or recompile postgres). I could also try to transfer the unaccent extension to the pg_catalog schema, but that is also seemingly impossible. | |
| Mar 28, 2018 at 22:58 | history | edited | Erwin Brandstetter |
edited tags
|
|
| Mar 28, 2018 at 22:57 | answer | added | Erwin Brandstetter | timeline score: 4 | |
| Mar 28, 2018 at 7:19 | history | asked | P.Péter | CC BY-SA 3.0 |