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.ko...@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
>
_______________________________________________
sr-dev mailing list
sr-dev@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
