Re: Tcl Support in the FC4 rpms at posgresql.org?

-----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(at)postgresql(dot)org Mon Nov 28 01:02:04 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 B4278DC053
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)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(dot)org(at)localhost(dot)postgresql(dot)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(at)postgresql(dot)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(at)postgresql(dot)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(at)postgresql(dot)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(at)postgresql(dot)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(at)postgresql(dot)org>; Sun, 27 Nov 2005 12:40:24 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-general(at)postgresql(dot)org
From: Haim Ashkenazi <haim(at)babysnakes(dot)org>
Subject: need help in designing a database.
Date: Sun, 27 Nov 2005 10:54:24 +0200
Lines: 29
Message-ID: <pan(dot)2005(dot)11(dot)27(dot)08(dot)54(dot)23(dot)524101(at)babysnakes(dot)org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet(at)sea(dot)gmane(dot)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