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