Re: Redhat 9 RPM dependency problem

Hi,

On Thu, 22 Sep 2005, han(dot)holl(at)tietoenator(dot)com wrote:

>
> If I run 'rpm -qp --requires postgresql-libs-8.0.3-1PGDG.i686.rpm' on a
> freshly downloaded RH9 rpm, I get:
>
> /sbin/ldconfig
> /sbin/ldconfig
> libc.so.6
> libc.so.6(GLIBC_2.0)
> libc.so.6(GLIBC_2.1)
> libc.so.6(GLIBC_2.1.3)
> libc.so.6(GLIBC_2.2)
> libc.so.6(GLIBC_2.3)
> libcom_err.so.2
> libcrypt.so.1
> libcrypt.so.1(GLIBC_2.0)
> libcrypto.so.4
> libecpg.so.4
> libm.so.6
> libm.so.6(GLIBC_2.0)
> libnsl.so.1
> libpgtypes.so.1
> libpq.so.3
> libresolv.so.2
> libssl.so.4
> rpmlib(CompressedFileNames) <= 3.0.4-1
> rpmlib(PayloadFilesHavePrefix) <= 4.0-1
>
> Notice libpq.so.3. and libecpg.so.4 (of the 7.x series).
>
> This means that 8.0.3 declares itself dependent on the earlier version of the
> libpq library, thus forcing me to install the compat-postgresql-libs, even
> though I have no software installed that actually needs the old libraries.
>
> This looks like a RPM packageing error, probably because of a problematic
> configuration on the machine of the packager.
> I did a rebuild from the source rpm, and now the phony dependencies are gone.

Sorry for the late response.

On my RH 9 box, I've rebuilt our SRPM and here is the result:

[root(at)evim SRPMS]# cat /etc/redhat-release
Red Hat Linux release 9 (Shrike)
[root(at)evim SRPMS]# rpm -qp --requires /usr/src/redhat/RPMS/i686/postgresql-libs-8.0.3-1PGDG.i686.rpm |grep libpq
libpq.so.4

It's the same box that I've built RH9 RPMs previously...

I'll upload the new RPMs now, maybe there were another problem during the
previous packaging.

Thanks.

--
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
>From pgsql-general-owner(at)postgresql(dot)org Fri Sep 30 16:14:15 2005
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id A6790D9BA4
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Fri, 30 Sep 2005 16:14:13 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 65657-10
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Fri, 30 Sep 2005 19:14:11 +0000 (GMT)
Received: from qproxy.gmail.com (qproxy.gmail.com [72.14.204.192])
by svr1.postgresql.org (Postfix) with ESMTP id 0B40ED9B8E
for <pgsql-general(at)postgresql(dot)org>; Fri, 30 Sep 2005 16:14:11 -0300 (ADT)
Received: by qproxy.gmail.com with SMTP id q10so108855qbq
for <pgsql-general(at)postgresql(dot)org>; Fri, 30 Sep 2005 12:14:12 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
s=beta; d=gmail.com;
h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references;
b=rqV91Hbi5wGW0K1eaEKe9KpNpflLMJjpo3azj7YRUWjPvAdRnSbQ+clvp1WPyfXq6e3XDQvAwH8bBIcVMdF3gQoq6ZrkJ730XrF0mieB22hkyth/ecfuBnEPB6/2XbmvtF29LQ+lFdpL3sTcw2deFEbWSCgaG/ku7h6yrO2w6ng=
Received: by 10.64.210.15 with SMTP id i15mr1091119qbg;
Fri, 30 Sep 2005 12:14:12 -0700 (PDT)
Received: by 10.65.38.16 with HTTP; Fri, 30 Sep 2005 12:14:12 -0700 (PDT)
Message-ID: <f817a44d0509301214l4f55e89cic7928040fecd3aa2(at)mail(dot)gmail(dot)com>
Date: Fri, 30 Sep 2005 15:14:12 -0400
From: Fernando Grijalba <fgrijalba(at)gmail(dot)com>
Reply-To: Fernando Grijalba <fgrijalba(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help with inventory control
In-Reply-To: <m2irwixzbo(dot)fsf(at)Douglas-McNaughts-Powerbook(dot)local>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_Part_5723_4619575.1128107652678"
References: <f817a44d0509300721u2c2baa59s2b1b71dbdd3661bb(at)mail(dot)gmail(dot)com>
<20050930154143(dot)GA29738(at)svana(dot)org>
<f817a44d0509300945j4e8ffe92i123233969d2f3bbb(at)mail(dot)gmail(dot)com>
<m2irwixzbo(dot)fsf(at)Douglas-McNaughts-Powerbook(dot)local>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=2.034 required=5 tests=[AWL=0.039, HTML_00_10=0.138,
HTML_MESSAGE=0.001, RCVD_BY_IP=0.024, RCVD_IN_BL_SPAMCOP_NET=1.832]
X-Spam-Level: **
X-Archive-Number: 200509/1206
X-Sequence-Number: 84221

------=_Part_5723_4619575.1128107652678
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Thank you for your input Doug, but that did not work. User2 was still
getting the qty unchanged.

Any more ideas?

I was thinking of creating a table that will hold the product code and the
qty taken by an order. check this table evey minute and if a product has
been there for more that 10 minutes and return it to inventory if that is
the case. After I save the order I would remove the prodcut for this order
from this table. This way I can just update the qty in one transaction when
the user gets the product for the order and then save the order in a
different transaction. This will allow me to reduce the quantity at the tim=
e
the order obtained the product and increase it when the order is cancelled
or if the user forgets or his/her computer crashes.

Is this a good idea? Your input is appreciated.

Fernando

------=_Part_5723_4619575.1128107652678
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Thank you for your input Doug, but that did not work. User2 was still getti=
ng the qty unchanged.<br>
<br>
Any more ideas?<br>
<br>
I was thinking of creating a table that will hold the product code and
the qty taken by an order.&nbsp; check this table evey minute and if a
product has been there for more that 10 minutes and return it to
inventory if that is the case.&nbsp; After I save the order I would
remove the prodcut for this order from this table.&nbsp; This way I can
just update the qty in one transaction when the user gets the product
for the order and then save the order in a different transaction.&nbsp;
This will allow me to reduce the quantity at the time the order
obtained the product and increase it when the order is cancelled or if
the user forgets or his/her computer crashes.<br>
<br>
Is this a good idea?&nbsp; Your input is appreciated.<br>
<br>
Fernando<br>

------=_Part_5723_4619575.1128107652678--