Tcl Support in the FC4 rpms at posgresql.org?

Hi,

On Sun, 27 Nov 2005, Jerry LeVan wrote:

Is Tcl support included in any of the FC4 rpms located
at postgresql.org? { I am talking about the 8.1 release }.

No.

If you need the tcl rpm, you need to rebuild our srpm:

rpm --rebuild --define 'tcl 1' postgresql-8.1.0-2PGDG.src.rpm

Regards,
--
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@postgresql.org Sun Nov 27 17:40:23 2005

X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 047F7D7065
for <pgsql-general-postgresql.org@localhost.postgresql.org>; Sun, 27 Nov 2005 17:40:23 -0400 (AST)
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 33453-04
for <pgsql-general-postgresql.org@localhost.postgresql.org>;
Sun, 27 Nov 2005 17:40:22 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from macjerry.localhost (richmond-bsr1-68-169-55-153.ironoh.adelphia.net [68.169.55.153])
by svr1.postgresql.org (Postfix) with ESMTP id E8E86DABB6
for <pgsql-general@postgresql.org>; Sun, 27 Nov 2005 17:40:19 -0400 (AST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
by macjerry.localhost (Postfix) with ESMTP id 4A8296B7581;
Sun, 27 Nov 2005 16:40:20 -0500 (EST)
In-Reply-To: <Pine.LNX.4.63.0511272103070.29024@mail.kivi.com.tr>
References: <CDE24D9C-81DC-4E60-9CCC-72CEB5F00C59@eku.edu> <Pine.LNX.4.63.0511272103070.29024@mail.kivi.com.tr>
Mime-Version: 1.0 (Apple Message framework v746.2)
Content-Type: text/plain; charset=UTF-8; delsp=yes; format=flowed
Message-Id: <48470EA3-732D-4FA0-8F99-F91847F19DA5@eku.edu>
Cc: Postgres General <pgsql-general@postgresql.org>,
pgsqlrpms-hackers@pgfoundry.org
Content-Transfer-Encoding: quoted-printable
From: Jerry LeVan <jerry.levan@eku.edu>
Subject: Re: Tcl Support in the FC4 rpms at posgresql.org?
Date: Sun, 27 Nov 2005 16:40:19 -0500
To: Devrim GUNDUZ <devrim@gunduz.org>
X-Mailer: Apple Mail (2.746.2)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=2.776 required=5 tests=[AWL=-0.925,
RCVD_IN_NJABL_DUL=1.713, RCVD_IN_SORBS_DUL=1.988]
X-Spam-Score: 2.776
X-Spam-Level: **
X-Archive-Number: 200511/1276
X-Sequence-Number: 87419

Hmm.

The "--rebuild" option is not recognized by the default rpm supplied
with FC4.

There is an rpmbuild command, but it always appears to do an "install".

Is there any way to simply build the binary rpms from the postgresql =20
src rpm
without doing an "install"?

Browsing about, I found the PostgreSQL-RPM-installation-PGDG.pdf =20
file. The
packages that it asserts will be build seem a bit different from what is
in the spec file.

In any case, from which directory should the rpmbuild command be given?

Thanks,

Jerry

On Nov 27, 2005, at 2:07 PM, Devrim GUNDUZ wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Sun, 27 Nov 2005, Jerry LeVan wrote:

The "--rebuild" option is not recognized by the default rpm supplied
with FC4.

Arrgh... It was also a typo in README.rpm-dist file :( I've fixed in our
CVS. (See below)

There is an rpmbuild command, but it always appears to do an "install".
Is there any way to simply build the binary rpms from the postgresql src rpm
without doing an "install"?

Yes, it should be rpmbuild --rebuild ...

If you want rpmbuild to clean all the files used during the build process,
then run:

rpmbuild --rmsource --clean --rebuild --define 'tcl 1' postgresql-8.1.0-2PGDG.src.rpm

Browsing about, I found the PostgreSQL-RPM-installation-PGDG.pdf file. The
packages that it asserts will be build seem a bit different from what is
in the spec file.

Well, we don't actually set all macros to 1. That's the only difference,
AFAICS. If you can see any more differences, please let us know and we'll
fix the document.

In any case, from which directory should the rpmbuild command be given?

It does not matter:

rpmbuild [blah blah] /path/to/source_rpm

Regards,
- --
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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDijRh4zE8DGqpiZARAr5nAJ0VlkooUcInc7SSlxmaBkvEZY7PyACfUvJH
kSy2Zajt8QzRfGyEcaYtLfk=
=kS9k
-----END PGP SIGNATURE-----

From pgsql-general-owner@postgresql.org Mon Nov 28 01:02:04 2005

X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id B4278DC053
for <pgsql-general-postgresql.org@localhost.postgresql.org>; Sun, 27 Nov 2005 10:57:23 -0400 (AST)
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 37321-04-2
for <pgsql-general-postgresql.org@localhost.postgresql.org>;
Sun, 27 Nov 2005 10:57:21 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25])
by svr1.postgresql.org (Postfix) with ESMTP id 3C153DC043
for <pgsql-general@postgresql.org>; Sun, 27 Nov 2005 10:57:17 -0400 (AST)
Received: from ciao.gmane.org (main.gmane.org [80.91.229.2])
by svr2.postgresql.org (Postfix) with ESMTP id 46D08F0C3A
for <pgsql-general@postgresql.org>; Sun, 27 Nov 2005 11:44:02 +0000 (GMT)
Received: from root by ciao.gmane.org with local (Exim 4.43)
id 1EgKtM-0003sq-Sk
for pgsql-general@postgresql.org; Sun, 27 Nov 2005 12:40:24 +0100
Received: from line22-41.adsl.actcom.co.il ([192.115.22.41])
by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
id 1AlnuQ-0007hv-00
for <pgsql-general@postgresql.org>; Sun, 27 Nov 2005 12:40:24 +0100
Received: from haim by line22-41.adsl.actcom.co.il with local (Gmexim 0.1 (Debian))
id 1AlnuQ-0007hv-00
for <pgsql-general@postgresql.org>; Sun, 27 Nov 2005 12:40:24 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-general@postgresql.org
From: Haim Ashkenazi <haim@babysnakes.org>
Subject: need help in designing a database.
Date: Sun, 27 Nov 2005 10:54:24 +0200
Lines: 29
Message-ID: <pan.2005.11.27.08.54.23.524101@babysnakes.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@sea.gmane.org
X-Gmane-NNTP-Posting-Host: line22-41.adsl.actcom.co.il
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0 required=5 tests=[none]
X-Spam-Score: 0
X-Spam-Level:
X-Archive-Number: 200511/1278
X-Sequence-Number: 87421

Hi

I'm writing an application that calculates working hours for billing.
there are three levels of billing. one for regular hours, one for
evening/nights, and one for saturdays/holidays.

My first decision is wether I make these calculations in a database view
(If I understand correctly, it would be calculated only once - when
creating the entry or modify it - or am I wrong?) or just put the
regular working hours in the database, and calculate it in the application
(and this way it would be calculated every time I view the page)?

If I'm right and it's better to put it in the database, I really need help
designing the database... (of-course it's an open-source project).

my idea is to create one table that define default hours/days ranges for
the three levels of billing, one table to define client specific ranges, a
table with charging information (charge per hour for every level of
billing for every customer), tables that define custommers, and job
details and a final view that summerize everything.

my main problem is how do I define an hour range from friday 15:00 to
sunday 08:00, and how to create a function that compares the working hours
with this range?

thanx
--
Haim