RE:

On 09-Sep-98 John Palmer wrote:
>
>
> Hi All,
>
> I am a FreeBSD 2.2.6 & LINUX (REDHAT 5.1) user. I have successfuly installed
> postgresql-6.3.2 in my FreeBSD system.Then I wanted to create some tables and
> use REFERENCES/FOREIGN KEY's. I saw some details about them in contrib/spi
> but
> I cannot compile and create in FreeBSD although LINUX is OK. I have included
> screen outputs for both systems.
>
> If anyone can give me some ideas how to compile them I will be very
> appreciated.

[RedHat Linux listing deleted]

># ******************************************************* #
># FreeBSD 2.2.6 Section #
># ******************************************************* #
>
>
> checking for readline/readline.h... yes
> checking for readline/history.h... yes
> checking for ieeefp.h... no
> checking for fp_class.h... no
> checking for netinet/in.h... yes
> checking for string.h... yes
> checking for strings.h... yes
> checking for working const... yes
> checking for uid_t in sys/types.h... yes
> checking for inline... inline
> checking for mode_t... yes
> checking for off_t... yes
> checking for size_t... yes
> checking whether time.h and sys/time.h may both be included... yes
> checking whether struct tm is in sys/time.h or time.h... time.h
> checking for int timezone... no
> checking for gettimeofday args... 2 args
> checking for union semun... yes
> checking whether gcc needs -traditional... no
> checking for 8-bit clean memcmp... yes
> checking return type of signal handlers... void
> checking for vprintf... yes
> checking for tzset... yes
> checking for vfork... yes
> checking for memmove... yes
> checking for sigsetjmp... yes
> checking for kill... yes
> checking for sysconf... yes
> checking for fpclass... no
> checking for fp_class... no
> checking for fp_class_d... no
> checking for class... no
> checking for sigprocmask... yes
> checking for waitpid... yes
> checking for setsid... yes
> checking for fcvt... no
> checking for isinf... yes
> checking for getrusage... yes
> checking for srandom... yes
> checking for gethostname... yes
> checking for random... yes
> checking for inet_aton... yes
> checking for strerror... yes
> checking for strdup... yes
> checking for strtol... yes
> checking for strtoul... yes
> checking for strcasecmp... yes
> checking for cbrt... yes
> checking for rint... yes
> updating cache ./config.cache
> creating ./config.status
> creating GNUmakefile
> creating Makefile.global
> creating backend/port/Makefile
> creating bin/pg_version/Makefile
> creating bin/psql/Makefile
> creating bin/pg_dump/Makefile
> creating backend/utils/Gen_fmgrtab.sh
> creating interfaces/libpq/Makefile
> creating interfaces/libpgtcl/Makefile
> creating interfaces/ecpg/lib/Makefile
> creating include/config.h
> linking ./backend/port/tas/dummy.s to backend/port/tas.s
> linking ./backend/port/dynloader/bsd.c to backend/port/dynloader.c
> linking ./backend/port/dynloader/bsd.h to include/dynloader.h
> linking ./include/port/bsd.h to include/os.h
> linking ./makefiles/Makefile.bsd to Makefile.port
> bash-2.01# cd ../contrib/
> bash-2.01# cd spi/
> bash-2.01# ls -al
> total 53
> drwxr-xr-x 2 pgsql wheel 512 Mar 20 02:13 .
> drwxr-xr-x 16 pgsql wheel 512 Mar 23 08:00 ..
> -rw-r--r-- 1 pgsql wheel 745 Jan 17 1998 Makefile
> -rw-r--r-- 1 pgsql wheel 5377 Oct 17 1997 README
> -rw-r--r-- 1 pgsql wheel 2761 Feb 26 1998 autoinc.c
> -rw-r--r-- 1 pgsql wheel 803 Oct 2 1997 autoinc.example
> -rw-r--r-- 1 pgsql wheel 117 Oct 2 1997 autoinc.source
> -rw-r--r-- 1 pgsql wheel 2368 Feb 26 1998 insert_username.c
> -rw-r--r-- 1 pgsql wheel 562 Oct 17 1997 insert_username.example
> -rw-r--r-- 1 pgsql wheel 141 Oct 17 1997 insert_username.source
> -rw-r--r-- 1 pgsql wheel 15593 Feb 26 1998 refint.c
> -rw-r--r-- 1 pgsql wheel 2110 Sep 12 1997 refint.example
> -rw-r--r-- 1 pgsql wheel 274 Sep 11 1997 refint.source
> -rw-r--r-- 1 pgsql wheel 10694 Feb 26 1998 timetravel.c
> -rw-r--r-- 1 pgsql wheel 2036 Oct 2 1997 timetravel.example
> -rw-r--r-- 1 pgsql wheel 278 Oct 2 1997 timetravel.source
> bash-2.01# make
> "../../src/Makefile.global", line 118: Need an operator
> "../../src/Makefile.global", line 122: Missing dependency operator
> "../../src/Makefile.global", line 126: Need an operator
> "../../src/Makefile.global", line 127: Missing dependency operator
> "../../src/Makefile.global", line 131: Need an operator
> "../../src/Makefile.global", line 132: Need an operator
> "../../src/Makefile.global", line 133: Need an operator
> "../../src/Makefile.global", line 203: Need an operator
> "../../src/Makefile.global", line 204: Could not find
> ../../src/Makefile.custom
> "../../src/Makefile.global", line 205: Need an operator
> "../../src/Makefile.global", line 210: Missing dependency operator
> "../../src/Makefile.global", line 212: Need an operator
> "../../src/Makefile.global", line 241: Missing dependency operator
> "../../src/Makefile.global", line 243: Need an operator
> "../../src/Makefile.global", line 245: Missing dependency operator
> "../../src/Makefile.global", line 247: Need an operator
> "../../src/Makefile.global", line 249: Missing dependency operator
> "../../src/Makefile.global", line 251: Need an operator
> "../../src/Makefile.global", line 253: Need an operator
> "../../src/Makefile.global", line 255: Need an operator
> "../../src/Makefile.global", line 257: Need an operator
> "../../src/Makefile.global", line 260: Need an operator
> "Makefile", line 10: Need an operator
> "Makefile", line 12: Need an operator
> make: fatal errors encountered -- cannot continue
> bash-2.01#

What do the "Makefile.global" lines that were flagged look like?
It's hard to guess without knowing more about this. It looks as though
the configure script is not building this file correctly, which means
that it is missing information, either in one of the files it uses to
build this file, or in the FreeBSD template ( in file
<postgres root>/src/template/freebsd ), or on your system (although it
appears to be finding what it needs there).

># ******************************************************* #
># End of FreeBSD 2.2.6 Section #
># ******************************************************* #

----------------------------------
Date: 09-Sep-98 Time: 12:18:06

Craig Orsinger (email: <orsingerc(at)epg(dot)lewis(dot)army(dot)mil>)
Logicon RDA
Bldg. 8B28 "Just another megalomaniac with ideas above his
6th & F Streets station. The Universe is full of them."
Ft. Lewis, WA 98433 - The Doctor
----------------------------------