Postgres: server version < 9.5 does not support insert_update
Hello List, I have just installed the version 5.1.6 and I get this warning message when Kamailio starts:
db_postgres_new_connection(): server version < 9.5 does not support insert_update
Does it mean Kamailio will not be working properly with my current Postgres Server (9.4)? What are the consequence of not having support for insert_update command? Best regards, Minh Phan
Hello, kamailio works fine if the database server does not support insert_update statement, this being used only if enabled via usrloc module parameter. Not being the developer of db postgres module, I guess the message is just an usual warning to make the voip admin aware and not enable use of this statement for user location/registrar. Cheers, Daniel On Tue, Oct 23, 2018 at 7:46 AM Minh Phan <mphan@mybestpro.com> wrote:
Hello List,
I have just installed the version 5.1.6 and I get this warning message when Kamailio starts:
db_postgres_new_connection(): server version < 9.5 does not support insert_update
Does it mean Kamailio will not be working properly with my current Postgres Server (9.4)? What are the consequence of not having support for insert_update command?
Best regards, Minh Phan
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Hello Daniel, Thank you for your response. It confirms what I found after searching through the code. Cheers, Minh Le mer. 24 oct. 2018 à 07:44, Daniel-Constantin Mierla <miconda@gmail.com> a écrit :
Hello,
kamailio works fine if the database server does not support insert_update statement, this being used only if enabled via usrloc module parameter. Not being the developer of db postgres module, I guess the message is just an usual warning to make the voip admin aware and not enable use of this statement for user location/registrar.
Cheers, Daniel
On Tue, Oct 23, 2018 at 7:46 AM Minh Phan <mphan@mybestpro.com> wrote:
Hello List,
I have just installed the version 5.1.6 and I get this warning message when Kamailio starts:
db_postgres_new_connection(): server version < 9.5 does not support insert_update
Does it mean Kamailio will not be working properly with my current Postgres Server (9.4)? What are the consequence of not having support for insert_update command?
Best regards, Minh Phan
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
This is correct, insert_update is used instead of insert when needed and available by userloc. This is providing better consistency in some cases, because the insert will not fail in case of constraint violation but will update instead last one will prevail. Not a problem, just a warning to let you know that you are missing a feature. Thanks for the answer. On Tue, Oct 23, 2018 at 10:44 PM Daniel-Constantin Mierla <miconda@gmail.com> wrote:
Hello,
kamailio works fine if the database server does not support insert_update statement, this being used only if enabled via usrloc module parameter. Not being the developer of db postgres module, I guess the message is just an usual warning to make the voip admin aware and not enable use of this statement for user location/registrar.
Cheers, Daniel
On Tue, Oct 23, 2018 at 7:46 AM Minh Phan <mphan@mybestpro.com> wrote:
Hello List,
I have just installed the version 5.1.6 and I get this warning message when Kamailio starts:
db_postgres_new_connection(): server version < 9.5 does not support insert_update
Does it mean Kamailio will not be working properly with my current Postgres Server (9.4)? What are the consequence of not having support for insert_update command?
Best regards, Minh Phan
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
participants (4)
-
Daniel-Constantin Mierla -
Julien Chavanton -
Minh Phan -
Minh Phan