Bug 444271

Summary: postgresql doesn't Require: matching release of postgresql-libs
Product: [Fedora] Fedora Reporter: Juha Tuomala <tuju>
Component: postgresqlAssignee: Tom Lane <tgl>
Status: CLOSED CURRENTRELEASE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: low Docs Contact:
Priority: low    
Version: 8CC: devrim, hhorak
Target Milestone: ---Keywords: Reopened
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: 8.3.3-1.fc9 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2008-06-13 14:28:35 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Juha Tuomala 2008-04-26 10:31:08 UTC
Description of problem:

The following has been done with yum:

rpm -qa --qf="%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}\n" |grep postgresql
postgresql-libs-8.2.6-1.fc8.x86_64
postgresql-8.2.7-1.fc8.x86_64
postgresql-server-8.2.7-1.fc8.x86_64

Expected results:

Same versions.

Comment 1 Tom Lane 2008-04-26 16:53:12 UTC
Hm, how did you get into this state ... did you do a "yum update" on postgresql-server only?

It looks like the base and server packages fail to require the libs package to be the exact same subrelease.  
I don't believe the configuration you have is "broken" exactly, but it's probably desirable to have the 
subpackages all get updated concurrently.

Comment 2 Juha Tuomala 2008-04-26 21:47:35 UTC
Yep, I've been lazy and just picked one package and thought that deps will take 
care the rest but didn't. Same happened with cups and bzip2.

Comment 3 Tom Lane 2008-04-26 22:58:36 UTC
OK, I'll tighten up the cross-package Requires.

Comment 4 Devrim GUNDUZ 2008-04-27 22:34:28 UTC
Tom, could you duplicate this? yum should have also upgraded -libs package,
since there is a new package that provides libpq.so.

I did not test though.

Comment 5 Tom Lane 2008-04-28 19:47:15 UTC
Verified --- "yum update postgresql-server" only updates the server and base packages, not libs.  I 
wouldn't have expected anything different; if I tell yum what to update, it shouldn't update anything that 
it's not directly required to by dependencies.

Comment 6 Tom Lane 2008-04-28 23:39:12 UTC
Done in CVS HEAD (F-10 to be).  Not sure when I'll get round to propagating this into the back branches.

Comment 7 Juha Tuomala 2008-04-29 06:15:17 UTC
Thanks :) I'm happy that it got fixed for the future at least.

Just wondering that how many of this kind pkgs are out there.

Comment 8 Fedora Update System 2008-06-11 20:42:33 UTC
postgresql-8.3.3-1.fc9 has been submitted as an update for Fedora 9

Comment 9 Fedora Update System 2008-06-13 02:22:54 UTC
postgresql-8.3.3-1.fc9 has been pushed to the Fedora 9 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 10 Juha Tuomala 2008-06-13 14:13:05 UTC
mmm...This bug was filed against f8. It still exists in f8 with the recent 
pgsql pkg updates.

For multi-release issues there is the cloning function:
https://bugzilla.redhat.com/enter_bug.cgi?cloned_bug_id=444271

Comment 11 Tom Lane 2008-06-13 14:28:35 UTC
I don't intend to fix it in F8.  Kindly don't make random replacements of bug subject lines ...

Comment 12 Juha Tuomala 2008-06-13 14:48:08 UTC
>   What    |Removed                     |Added
> ----------------------------------------------------------------
>  Summary|broken dependencies         |postgresql doesn't Require:

> I don't intend to fix it in F8.

F8 *is* current release. If you want to kill it, I suggest to take it
into fedora-devel mailing list. 

> Kindly don't make random replacements of bug subject lines ...

How about adding the product and Cc fields into subject too?