General Bug Report: Missing include files to compile SPI programmes

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Adriaan Joubert
Your email address : a(dot)joubert(at)albourne(dot)com

Category : install: other
Severity : non-critical

Summary: Missing include files to compile SPI programmes

System Configuration
--------------------
Operating System : DEC Unix 4.0D

PostgreSQL version : 6.5

Compiler used : native cc

Hardware:
---------
DEC 8200, 640MB Ram

Versions of other tools:
------------------------

--------------------------------------------------------------------------

Problem Description:
--------------------
./pgsql/include does not include all include files that are required to
compile a routine that uses SPI.

--------------------------------------------------------------------------

Test Case:
----------
Try to compile anything that includes

#include "executor/spi.h"

--------------------------------------------------------------------------

Solution:
---------
Don't know how to patch it, but I got it to compile after copying the following include files to ./pgsql/include (I included all of the storage/ directory, as I got fed-up with copying them one-by-one, but otherwise this should be a minimal set):

./lib/fstack.h
./utils/fcache.h
./utils/memutils.h
./utils/nabstime.h
./utils/dt.h
./utils/rel.h
./utils/tqual.h
./utils/datum.h
./utils/syscache.h
./utils/portal.h
./utils/builtins.h
./utils/array.h
./utils/datetime.h
./utils/int8.h
./utils/cash.h
./utils/inet.h
./utils/numeric.h
./utils/hsearch.h
./access/htup.h
./access/relscan.h
./access/strat.h
./access/skey.h
./access/tupdesc.h
./access/sdir.h
./access/funcindex.h
./access/heapam.h
./access/tupmacs.h
./access/xact.h
./access/transam.h
./access/itup.h
./access/ibit.h
./executor/hashjoin.h
./executor/tuptable.h
./executor/execdesc.h
./executor/executor.h
./executor/execdefs.h
./nodes/primnodes.h
./nodes/pg_list.h
./nodes/nodes.h
./nodes/relation.h
./nodes/parsenodes.h
./nodes/execnodes.h
./nodes/memnodes.h
./nodes/params.h
./nodes/plannodes.h
./storage/*.h
./catalog/pg_am.h
./catalog/pg_class.h
./catalog/pg_attribute.h
./catalog/pg_proc.h
./catalog/pg_type.h
./catalog/pg_language.h
./catalog/pg_index.h
./catalog/catname.h
./rewrite/prs2lock.h
./tcop/dest.h
./tcop/pquery.h
./tcop/tcopprot.h
./tcop/utility.h
./parser/parse_node.h
./parser/parse_type.h

--------------------------------------------------------------------------