HI,
as a quick workaround, you can set the new field name for "authorization_column"
----- code start ---- #PostgreSQL don't like "authorization" modparam("sipcapture", "authorization_column", "auth"); ----- code end ----
and change the db schema for postgress.
or i can do opposite, rename the "authorization" field to "auth" and for back compatibility use modparam.
Wbr, Alexandr
P.S. as another way, use escape characters for fields.
2013/1/17 Øyvind Kolbu oyvind.kolbu@usit.uio.no
Hi,
while porting the MySQL schema to PostgreSQL I've found that it has a column named "authorization", which is a reserved SQL key word, see http://www.postgresql.org/docs/9.2/static/sql-keywords-appendix.html. MySQL should not have accepted it. Would be nice if this could be changed before 4.0.
-- Øyvind Kolbu
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev