17 Jan
2013
17 Jan
'13
8:08 a.m.
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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev