Thread

General Bug Report: Missing include files to compile SPI programmes

Unprivileged user <nobody> — 1999-06-29T07:31:59Z

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


Your name               : Adriaan Joubert
Your email address      : a.joubert@albourne.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


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