17 Jan
2013
17 Jan
'13
4:14 a.m.
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
17 Jan
17 Jan
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
8:20 a.m.
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.
--
Øyvind
10:46 a.m.
On 1/17/13 2:22 PM, Alexandr Dubovikov wrote:
2013/1/17 Øyvind Kolbu <oyvind.kolbu(a)usit.uio.no
<mailto:oyvind.kolbu@usit.uio.no>>
authorization
Daniel, 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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
4187
days inactive
4187
days old
4 comments
3 participants
participants (3)
-
Alexandr Dubovikov -
Daniel-Constantin Mierla -
Øyvind Kolbu