OESA-2021-1124

See a problem?
Please try reporting it to the source first.
Source
https://www.openeuler.org/en/security/security-bulletins/detail/?id=openEuler-SA-2021-1124
Import Source
https://repo.openeuler.org/security/data/osv/OESA-2021-1124.json
JSON Data
https://api.test.osv.dev/v1/vulns/OESA-2021-1124
Upstream
Published
2021-04-07T11:02:46Z
Modified
2025-08-12T05:07:00.560998Z
Summary
postgresql security update
Details

PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions). The postgresql package includes the client programs and libraries that you'll need to access a PostgreSQL DBMS server.

Security Fix(es):

A flaw was found in PostgreSQL in versions before 13.2, before 12.6, before 11.11, before 10.16, before 9.6.21 and before 9.5.25. This flaw allows a user with SELECT privilege on one column to craft a special query that returns all columns of the table. The highest threat from this vulnerability is to confidentiality.(CVE-2021-20229)

Database specific 
{
    "severity": "Medium"
}
References

Affected packages

openEuler:20.03-LTS / postgresql

Package

Name
postgresql
Purl
pkg:rpm/openEuler/postgresql&distro=openEuler-20.03-LTS

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected
Fixed
10.5-21.oe1

Ecosystem specific 

{
    "x86_64": [
        "postgresql-debuginfo-10.5-20.oe1.x86_64.rpm",
        "postgresql-libs-10.5-20.oe1.x86_64.rpm",
        "postgresql-plpython3-10.5-20.oe1.x86_64.rpm",
        "postgresql-help-10.5-20.oe1.x86_64.rpm",
        "postgresql-plperl-10.5-20.oe1.x86_64.rpm",
        "postgresql-10.5-20.oe1.x86_64.rpm",
        "postgresql-debugsource-10.5-20.oe1.x86_64.rpm",
        "postgresql-test-10.5-20.oe1.x86_64.rpm",
        "postgresql-contrib-10.5-20.oe1.x86_64.rpm",
        "postgresql-devel-10.5-20.oe1.x86_64.rpm",
        "postgresql-server-10.5-20.oe1.x86_64.rpm",
        "postgresql-static-10.5-20.oe1.x86_64.rpm",
        "postgresql-pltcl-10.5-20.oe1.x86_64.rpm",
        "postgresql-test-rpm-macros-10.5-20.oe1.x86_64.rpm",
        "postgresql-test-rpm-macros-10.5-21.oe1.x86_64.rpm",
        "postgresql-contrib-10.5-21.oe1.x86_64.rpm",
        "postgresql-help-10.5-21.oe1.x86_64.rpm",
        "postgresql-devel-10.5-21.oe1.x86_64.rpm",
        "postgresql-debugsource-10.5-21.oe1.x86_64.rpm",
        "postgresql-debuginfo-10.5-21.oe1.x86_64.rpm",
        "postgresql-static-10.5-21.oe1.x86_64.rpm",
        "postgresql-server-10.5-21.oe1.x86_64.rpm",
        "postgresql-10.5-21.oe1.x86_64.rpm",
        "postgresql-test-10.5-21.oe1.x86_64.rpm",
        "postgresql-pltcl-10.5-21.oe1.x86_64.rpm",
        "postgresql-libs-10.5-21.oe1.x86_64.rpm",
        "postgresql-plpython3-10.5-21.oe1.x86_64.rpm",
        "postgresql-plperl-10.5-21.oe1.x86_64.rpm"
    ],
    "aarch64": [
        "postgresql-test-10.5-20.oe1.aarch64.rpm",
        "postgresql-debuginfo-10.5-20.oe1.aarch64.rpm",
        "postgresql-help-10.5-20.oe1.aarch64.rpm",
        "postgresql-10.5-20.oe1.aarch64.rpm",
        "postgresql-debugsource-10.5-20.oe1.aarch64.rpm",
        "postgresql-plperl-10.5-20.oe1.aarch64.rpm",
        "postgresql-plpython3-10.5-20.oe1.aarch64.rpm",
        "postgresql-libs-10.5-20.oe1.aarch64.rpm",
        "postgresql-server-10.5-20.oe1.aarch64.rpm",
        "postgresql-pltcl-10.5-20.oe1.aarch64.rpm",
        "postgresql-contrib-10.5-20.oe1.aarch64.rpm",
        "postgresql-test-rpm-macros-10.5-20.oe1.aarch64.rpm",
        "postgresql-devel-10.5-20.oe1.aarch64.rpm",
        "postgresql-static-10.5-20.oe1.aarch64.rpm",
        "postgresql-test-rpm-macros-10.5-21.oe1.aarch64.rpm",
        "postgresql-test-10.5-21.oe1.aarch64.rpm",
        "postgresql-server-10.5-21.oe1.aarch64.rpm",
        "postgresql-plperl-10.5-21.oe1.aarch64.rpm",
        "postgresql-help-10.5-21.oe1.aarch64.rpm",
        "postgresql-contrib-10.5-21.oe1.aarch64.rpm",
        "postgresql-static-10.5-21.oe1.aarch64.rpm",
        "postgresql-debugsource-10.5-21.oe1.aarch64.rpm",
        "postgresql-libs-10.5-21.oe1.aarch64.rpm",
        "postgresql-debuginfo-10.5-21.oe1.aarch64.rpm",
        "postgresql-pltcl-10.5-21.oe1.aarch64.rpm",
        "postgresql-plpython3-10.5-21.oe1.aarch64.rpm",
        "postgresql-10.5-21.oe1.aarch64.rpm",
        "postgresql-devel-10.5-21.oe1.aarch64.rpm"
    ],
    "src": [
        "postgresql-10.5-20.oe1.src.rpm",
        "postgresql-10.5-21.oe1.src.rpm"
    ]
}

openEuler:20.03-LTS-SP1 / postgresql

Package

Name
postgresql
Purl
pkg:rpm/openEuler/postgresql&distro=openEuler-20.03-LTS-SP1

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected
Fixed
10.5-21.oe1

Ecosystem specific 

{
    "x86_64": [
        "postgresql-test-rpm-macros-10.5-21.oe1.x86_64.rpm",
        "postgresql-contrib-10.5-21.oe1.x86_64.rpm",
        "postgresql-help-10.5-21.oe1.x86_64.rpm",
        "postgresql-devel-10.5-21.oe1.x86_64.rpm",
        "postgresql-debugsource-10.5-21.oe1.x86_64.rpm",
        "postgresql-debuginfo-10.5-21.oe1.x86_64.rpm",
        "postgresql-static-10.5-21.oe1.x86_64.rpm",
        "postgresql-server-10.5-21.oe1.x86_64.rpm",
        "postgresql-10.5-21.oe1.x86_64.rpm",
        "postgresql-test-10.5-21.oe1.x86_64.rpm",
        "postgresql-pltcl-10.5-21.oe1.x86_64.rpm",
        "postgresql-libs-10.5-21.oe1.x86_64.rpm",
        "postgresql-plpython3-10.5-21.oe1.x86_64.rpm",
        "postgresql-plperl-10.5-21.oe1.x86_64.rpm"
    ],
    "aarch64": [
        "postgresql-test-rpm-macros-10.5-21.oe1.aarch64.rpm",
        "postgresql-test-10.5-21.oe1.aarch64.rpm",
        "postgresql-server-10.5-21.oe1.aarch64.rpm",
        "postgresql-plperl-10.5-21.oe1.aarch64.rpm",
        "postgresql-help-10.5-21.oe1.aarch64.rpm",
        "postgresql-contrib-10.5-21.oe1.aarch64.rpm",
        "postgresql-static-10.5-21.oe1.aarch64.rpm",
        "postgresql-debugsource-10.5-21.oe1.aarch64.rpm",
        "postgresql-libs-10.5-21.oe1.aarch64.rpm",
        "postgresql-debuginfo-10.5-21.oe1.aarch64.rpm",
        "postgresql-pltcl-10.5-21.oe1.aarch64.rpm",
        "postgresql-plpython3-10.5-21.oe1.aarch64.rpm",
        "postgresql-10.5-21.oe1.aarch64.rpm",
        "postgresql-devel-10.5-21.oe1.aarch64.rpm"
    ],
    "src": [
        "postgresql-10.5-21.oe1.src.rpm"
    ]
}