BUG #17507: rpm packages provide wrong postgresql version

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: postgresql(dot)org(at)bluhm-de(dot)com
Subject: BUG #17507: rpm packages provide wrong postgresql version
Date: 2022-06-01 19:49:22
Message-ID: 17507-7c4325dda6d8445f@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17507
Logged by: Stefan Bluhm
Email address: postgresql(dot)org(at)bluhm-de(dot)com
PostgreSQL version: 14.3
Operating system: AlmaLinux9
Description:

Issue:
The provided rpm packages provide incorrect postgersql version information
for PostgreSQL 14.* (only tested 14).

How to reproduce:
- Use Enterprise Linux 8 or 9.
- Use the packages from repositories
https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
or
https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
- check the provided versions:
# dnf repoquery --provides postgresql14

Output:
postgresql >= 14.0-1PGDG.rhel8
postgresql >= 14.1-1PGDG.rhel8
postgresql >= 14.2-1PGDG.rhel8
postgresql >= 14.2-4PGDG.rhel8
postgresql >= 14.3-1PGDG.rhel8

This is false. a package shouldn't provide ">=" a specific version. This
will cause resolution errors with librepo.

Example RPM line

Requires: postgresql >= 14
Conflicts: postgresql > 20

User expectation: Postgresql 14 or higher will be installed. Postgresql 20
or higher will not be installed.
Actually nothing will be installed. Postgresql 14 will be selected for
installation but conflicts with itself as it is also providing anything
higher than 20.

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-06-02 02:02:38 BUG #17508: ja.po for pg_ctl has an obvious mistake
Previous Message PG Bug reporting form 2022-06-01 12:03:35 BUG #17506: Issue with the downloading site