USN-3818-1

It was discovered that PostgreSQL incorrectly handled certain trigger definitions when running pgupgrade or pgdump. A remote attacker could possibly use this issue to execute arbitrary SQL statements with superuser privileges.

References

Affected packages

Ubuntu:18.04:LTS / postgresql-10

Package

Name: postgresql-10
Purl: pkg:deb/ubuntu/postgresql-10@10.6-0ubuntu0.18.04.1?arch=source&distro=bionic

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

10.6-0ubuntu0.18.04.1

Affected versions

10.*

10.1-1

10.1-2

10.2-1

10.3-1

10.4-0ubuntu0.18.04

10.5-0ubuntu0.18.04

Ecosystem specific

{
    "availability": "No subscription required",
    "binaries": [
        {
            "binary_name": "libecpg-compat3",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "libecpg-compat3-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "libecpg-dev",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "libecpg-dev-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "libecpg6",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "libecpg6-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "libpgtypes3",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "libpgtypes3-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "libpq-dev",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "libpq5",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "libpq5-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-10",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-10-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-client-10",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-client-10-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-doc-10",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-plperl-10",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-plperl-10-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-plpython-10",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-plpython-10-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-plpython3-10",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-plpython3-10-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-pltcl-10",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-pltcl-10-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-server-dev-10",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        },
        {
            "binary_name": "postgresql-server-dev-10-dbgsym",
            "binary_version": "10.6-0ubuntu0.18.04.1"
        }
    ]
}