<div dir="ltr">HI,<div><br></div><div style>as a quick workaround, you can set the new field name for "authorization_column"</div><div style><div><br></div><div style>----- code start ----</div><div style>#PostgreSQL don't like "<span style="font-family:arial,sans-serif;font-size:13px">authorization</span>"</div>
<div>modparam("sipcapture", "authorization_column", "auth");</div><div>----- code end ----<br></div><div><br></div><div style>and change the db schema for postgress.</div><div style><br></div>
<div style>or i can do opposite, rename the "authorization" field to "auth" and for back compatibility use modparam.</div><div style> </div><div style><br></div><div style>Wbr,</div><div style>Alexandr</div>
<div style><br></div><div style>P.S. as another way, use escape characters for fields.</div><div><br></div></div><div style><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/1/17 Øyvind Kolbu <span dir="ltr"><<a href="mailto:oyvind.kolbu@usit.uio.no" target="_blank">oyvind.kolbu@usit.uio.no</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
while porting the MySQL schema to PostgreSQL I've found that it has<br>
a column named "authorization", which is a reserved SQL key word, see<br>
<<a href="http://www.postgresql.org/docs/9.2/static/sql-keywords-appendix.html" target="_blank">http://www.postgresql.org/docs/9.2/static/sql-keywords-appendix.html</a>>.<br>
MySQL should not have accepted it. Would be nice if this could be changed<br>
before 4.0.<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Øyvind Kolbu<br>
<br>
_______________________________________________<br>
sr-dev mailing list<br>
<a href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a><br>
</font></span></blockquote></div><br></div>