Notes on Postgresql 7.0 on FreeBSD

============================================================================
                        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 				/* 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