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.

YOURS DESPERATELY

John Palmer

# ******************************************************* #
# Linux (Redhat 5.1) Section #
# ******************************************************* #

[root(at)speedy src]# cd /home/ftp/incoming/postgresql-6.3.2/contrib/
[root(at)speedy spi]# make
gcc -I../../src/include -I../../src/backend -Wall -Wmissing-prototypes
-fpic -I../../src/include -c refint.c -o refint.o
gcc -shared -o refint.so refint.o
rm -f refint.sql; \
C=`pwd`; \
sed -e "s:_OBJWD_:/usr/local/pgsql/lib/contrib:g" \
-e "s:_DLSUFFIX_:.so:g" < refint.source > refint.sql
gcc -I../../src/include -I../../src/backend -Wall -Wmissing-prototypes
-fpic -I../../src/include -c timetravel.c -o timetravel.o
gcc -shared -o timetravel.so timetravel.o
rm -f timetravel.sql; \
C=`pwd`; \
sed -e "s:_OBJWD_:/usr/local/pgsql/lib/contrib:g" \
-e "s:_DLSUFFIX_:.so:g" < timetravel.source > timetravel.sql
gcc -I../../src/include -I../../src/backend -Wall -Wmissing-prototypes
-fpic -I../../src/include -c autoinc.c -o autoinc.o
gcc -shared -o autoinc.so autoinc.o
rm -f autoinc.sql; \
C=`pwd`; \
sed -e "s:_OBJWD_:/usr/local/pgsql/lib/contrib:g" \
-e "s:_DLSUFFIX_:.so:g" < autoinc.source > autoinc.sql
gcc -I../../src/include -I../../src/backend -Wall -Wmissing-prototypes
-fpic -I../../src/include -c insert_username.c -o insert_username.o
gcc -shared -o insert_username.so insert_username.o
rm -f insert_username.sql; \
C=`pwd`; \
sed -e "s:_OBJWD_:/usr/local/pgsql/lib/contrib:g" \
-e "s:_DLSUFFIX_:.so:g" < insert_username.source > insert_username.sql
rm refint.o autoinc.o insert_username.o timetravel.o
[root(at)speedy spi]# ls -al
total 92
drwxr-xr-x 2 1005 wheel 1024 Sep 9 15:36 .
drwxr-xr-x 16 1005 wheel 1024 Mar 23 08:00 ..
-rw-r--r-- 1 1005 wheel 745 Jan 17 1998 Makefile
-rw-r--r-- 1 1005 wheel 5377 Oct 17 1997 README
-rw-r--r-- 1 1005 wheel 2761 Feb 26 1998 autoinc.c
-rw-r--r-- 1 1005 wheel 803 Oct 2 1997 autoinc.example
-rwxrwxr-x 1 root root 5936 Sep 9 15:35 autoinc.so
-rw-r--r-- 1 1005 wheel 117 Oct 2 1997 autoinc.source
-rw-rw-r-- 1 root root 131 Sep 9 15:35 autoinc.sql
-rw-r--r-- 1 1005 wheel 2368 Feb 26 1998 insert_username.c
-rw-r--r-- 1 1005 wheel 562 Oct 17 1997 insert_username.example
-rwxrwxr-x 1 root root 5449 Sep 9 15:36 insert_username.so
-rw-r--r-- 1 1005 wheel 141 Oct 17 1997 insert_username.source
-rw-rw-r-- 1 root root 155 Sep 9 15:36 insert_username.sql
-rw-r--r-- 1 1005 wheel 15593 Feb 26 1998 refint.c
-rw-r--r-- 1 1005 wheel 2110 Sep 12 1997 refint.example
-rwxrwxr-x 1 root root 10938 Sep 9 15:35 refint.so
-rw-r--r-- 1 1005 wheel 274 Sep 11 1997 refint.source
-rw-rw-r-- 1 root root 302 Sep 9 15:35 refint.sql
-rw-r--r-- 1 1005 wheel 10694 Feb 26 1998 timetravel.c
-rw-r--r-- 1 1005 wheel 2036 Oct 2 1997 timetravel.example
-rwxrwxr-x 1 root root 10653 Sep 9 15:35 timetravel.so
-rw-r--r-- 1 1005 wheel 278 Oct 2 1997 timetravel.source
-rw-rw-r-- 1 root root 306 Sep 9 15:35 timetravel.sql
[root(at)speedy spi]# cat timetravel.sql
DROP FUNCTION timetravel();
DROP FUNCTION set_timetravel(name, int4);

CREATE FUNCTION timetravel()
RETURNS opaque
AS '/usr/local/pgsql/lib/contrib/timetravel.so'
LANGUAGE 'c';

CREATE FUNCTION set_timetravel(name, int4)
RETURNS int4
AS '/usr/local/pgsql/lib/contrib/timetravel.so'
LANGUAGE 'c';
[root(at)speedy spi]#

# ******************************************************* #
# End of Linux (Redhat 5.1) Section #
# ******************************************************* #

# ******************************************************* #
# 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#

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

-

John Palmer Eurepean IS Manager
--------------------------------------------------------------
E-mail: jpalmer(at)acucobol(dot)co(dot)uk Acucorp UK,
Phone : +44 (0)181 707 2060 9th Floor, 42 The Centre,
Fax : +44 (0)181 707 2055 Highfield Road, Feltham,
Mobile: +44 (0)402 37775 Middlesex, TW13 4AU
WWW : http://www.acucorp.com United Kingdom
--------------------------------------------------------------