Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 07 Oct 2019 14:31:04 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 241116] net/asterisk16: fix cdr_pgsql for PostgreSQL 12
Message-ID:  <bug-241116-7788@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D241116

            Bug ID: 241116
           Summary: net/asterisk16: fix cdr_pgsql for PostgreSQL 12
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
               URL: https://issues.asterisk.org/jira/browse/ASTERISK-28571
                OS: Any
            Status: New
          Keywords: easy, patch, patch-ready
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: madpilot@FreeBSD.org
          Reporter: cmt@freebsd.org
          Assignee: madpilot@FreeBSD.org
             Flags: maintainer-feedback?(madpilot@FreeBSD.org)

Created attachment 208153
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=3D208153&action=
=3Dedit
fix cdr_pgsql to work with all modern PostgreSQL versions (>8.0)

The SQL statement for discovering the cdr table tries to access a column wh=
ich
has been obsolteted for a long time and was removed in PostgreSQL 12 (see
upstream bug for full discussion).

Attached patch (to be dropped in files/) makes sure cdr_pgsql works with all
supported (and much more) versions of PostgreSQL. It should work with
net/asterisk13 as well (I'm not filing another, redundant PR for that).

--=20
You are receiving this mail because:
You are the assignee for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-241116-7788>