[asterisk-bugs] [JIRA] (ASTERISK-29293) res_config_pgsql: Limit realtime_pgsql() to return one (no more) record

[Kevin Harwell (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-29293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kevin Harwell updated ASTERISK-29293:
-------------------------------------

    Status: Open  (was: Triage)

> res_config_pgsql: Limit realtime_pgsql() to return one (no more) record
> -----------------------------------------------------------------------
>
>                 Key: ASTERISK-29293
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29293
>             Project: Asterisk
>          Issue Type: Improvement
>      Security Level: None
>          Components: Resources/res_config_pgsql
>    Affects Versions: 16.16.0, 18.2.0
>            Reporter: Boris P. Korzun
>
> There's no a SELECT {{LIMIT}} clause in {{realtime_pgsql()}}. But there's the limit in {{realtime_handler()}} at res_config_sqlite.
> It's needed to use {{realtime_multi_pgsql()}} for getting multiple rows from an SQL query.
> It's suggested to add {{LIMIT}} clause to {{realtime_pgsql()}} and refactor the function.



--
This message was sent by Atlassian JIRA
(v6.2#6252)