We, that is, Geoffrey, applied the patch and rebuilt the rpm's. I have
installed the new rpm and the problem is resolved. We are in the process of
converting a transportation package from a commercial database product to
Postgres. On at least two occassions, I have reported bugs to that software
company, and the bugs were never fixed. We were given work-around hacks and
that was it. We discovered this problem yesterday and it is fixed today. I
guess that is one of many GREAT things about Open Source software ;o)
Thanks to everyone who responded, and especially to Tom Lane, who provided the
patch.
On Wednesday 12 January 2005 04:32 am, Marco Colombo saith:
> On Tue, 11 Jan 2005, Geoffrey wrote:
> > Tom Lane wrote:
> >> Terry Lee Tucker <terry@esc1.com> writes:
> >>> Apparently, if DateStyle is set to Sql, it always returns the absolute
> >>> value.
> >>> Is this due to some Sql standard or is it a bug?
> >>
> >> It's a bug in interval_out. Looks like it gets it wrong for GERMAN
> >> style too. Surprising no one noticed before.
> >
> > Any idea when I might be able to put my hands on Red Hat 3 rpm versions
> > that include this fix?
> >
> > Currently running postgresql-server-7.4.6-2PGDG
> > and would like to stick with the same version. It'd be a whole lot
> > easier to apply the fix via rpm rather then having to build from source.
>
> If you really need it, you can rebuild the rpm itself from the .src.rpm.
> Adding a small patch is quite easy, even if you're not familiar
> with spec files. Usually there are other patches already, all you need
> is to move the patch file to the right place (SOURCES in the rpm tree)
> and add one PatchXXX: and one %patchXXX line. Then use rpmbuild
> (note that you need the development set of packages installed, of course).
>
> .TM.
> --
> ____/ ____/ /
> / / / Marco Colombo
> ___/ ___ / / Technical Manager
> / / / ESI s.r.l.
> _____/ _____/ _/ Colombo@ESI.it
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
Work: 1-336-372-6812
Cell: 1-336-363-4719
email: terry@esc1.com
