Re: [PORTS] Notes on Postgresql 7.0 on FreeBSD

Applied.


> ============================================================================
>                         POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
>
> Your name               : Rolf Grossmann
> Your email address      : grossman@securitas.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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026