[ERR] mod_pgsql.c:556 Error executing query

toraton2003

New Member
Nov 24, 2021
6
0
1
56
Hello, I would like to report a warning I received after switching from SQLite to `core.db` in PostgreSQL. I believe the solution might be to change the table structure to use the `text` type instead of `varchar`. Before making the change manually, I would like to know if there is a different way to handle this issue. Thanks.
The error is:
2026-08-08 10:34:11.966973 98.63% [ERR] mod_pgsql.c:556 Error executing query:
ERRORE: il valore è troppo lungo per il tipo character varying(4096)
 
Not seeing it my logs. Any indication on what table this is referring to? If you manually modify the tables, ensure you disable 'auto-create-schemas' (and I think auto-clear-sql) in the FreeSWITCH switch.conf.xml config as that will probably just override it next time you restart.

I get the feeling that FreeSWITCH really just wants to be in sqlite on a RAM disk sometimes.