Re: [PORTS] Notes on Postgresql 7.0 on FreeBSD

Applied.

> ============================================================================
> POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
>
> Your name : Rolf Grossmann
> Your email address : grossman(at)securitas(dot)net
>
>
> System Configuration
> ---------------------
> Architecture (example: Intel Pentium) : AMD-K6 300
>
> Operating System (example: Linux 2.0.26 ELF) : FreeBSD 3.4-STABLE
>
> PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0beta1
>
> Compiler used (example: gcc 2.8.0) : gcc 2.95
>
>
> Please enter a FULL description of your problem:
> ------------------------------------------------
>
> Actually, I have found 2 platform specific problems:
>
> 1. miscadmin.h needs to include sys/types.h for a definition of pid_t
>
> This patch fixes the problem.
>
> *** miscadmin.h.orig Wed Feb 23 14:31:08 2000
> --- miscadmin.h Tue Feb 22 18:27:48 2000
> ***************
> *** 24,27 ****
> --- 24,29 ----
> #define MISCADMIN_H
>
> + #include <sys/types.h> /* For pid_t */
> +
> #include "postgres.h"
>
> 2. Regression tests fail for types int2 and int4 (which can easily be
> fixed by adding entries to resultmap) aswell as float8 and geometry,
> where floating point numbers appear to be rounded a little differently
> than in your expected results (besides that I also need the positive
> zeros file). I'm including a patch for the first 2, but I don't know
> whether the latter two are actually a bug in postgres or a bug in the
> OS or even allowed difference. I'm including my results for reference.
>
> *** resultmap.orig Wed Feb 23 14:33:19 2000
> --- resultmap Wed Feb 23 13:20:06 2000
> ***************
> *** 3,6 ****
> --- 3,8 ----
> int2/.*-netbsd=int2-too-large
> int4/.*-netbsd=int4-too-large
> + int2/.*-freebsd=int2-too-large
> + int4/.*-freebsd=int4-too-large
> int2/i.86-pc-linux-gnulibc=int2-not-representable
> int4/i.86-pc-linux-gnulibc=int4-not-representable
> ***************
> *** 9,12 ****
> --- 11,15 ----
> geometry/hppa=geometry-positive-zeros
> geometry/.*-netbsd=geometry-positive-zeros
> + geometry/.*-freebsd=geometry-positive-zeros
> geometry/i.86-.*-gnulibc=geometry-i86-gnulibc
> geometry/sparc-sun-solaris=geometry-solaris-precision
>
> Thanks for your attention and keep up the good work.
>
> Bye, Rolf
>
> ************
>
>

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026