Notes on Postgresql 7.0 on FreeBSD

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