Asterisk 17.2.0 Realtime Postgresql 11

Colleagues, good afternoon. Ask for help. Configured asterisk 17.2.0 + ODBC in real time + PostgreSQL with 11. Everything works well, however, when you enable the subscriber registration record in the database (PS ps_contacts), I get these errors in the console. I can’t figure out what to do.

Try turning up PostgreSQL logging to capture the entire query that is failing, then restart your box.

Your log output indicates a column type mismatch between integers and characters. So either Asterisk is saying “integer” and PostgreSQL is saying “nope, its character column” or Asterisk is saying “character” and PostgreSQL is saying “nope, its integer column”.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.