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.
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
On 17.01.2013 14:08, Alexandr Dubovikov wrote:
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 ----
The SQL standard doesn't like "authorization" and neither should MySQL.
and change the db schema for postgress.
or i can do opposite, rename the "authorization" field to "auth" and for back compatibility use modparam.
Thanks, but it should be done properly as the same change must also be done in Homer. Thus update the general/mysql schema to not use SQL reserved key words.
authorization -> auth is fine by me.
2013/1/17 Øyvind Kolbu oyvind.kolbu@usit.uio.no
authorization
Daniel, can I fix it ? Can we accept this as bug fix ? ;-)
Wbr, Alexandr
On 1/17/13 2:22 PM, Alexandr Dubovikov wrote:
2013/1/17 Øyvind Kolbu <oyvind.kolbu@usit.uio.no mailto:oyvind.kolbu@usit.uio.no>
authorizationDaniel, can I fix it ? Can we accept this as bug fix ? ;-)
It's fine, as I understood is a reserved keyword.
Cheers, Daniel
Wbr, Alexandr
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
-
Alexandr Dubovikov -
Daniel-Constantin Mierla -
Øyvind Kolbu