[sr-dev] sipcapture uses reserved SQL key word as column name

[Alexandr Dubovikov]

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 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130117/a50059ee/attachment.htm>