I'm having trouble with pgxs and it seems like either it's doing something actively wrong which defeats the purpose of having pgxs or I'm doing something wrong in how I'm using it.
I have postgres installed in /usr/local/pgsql in addition to having the debian packages installed in the usual places. My Makefile explicitly calls the development install: PGXS := $(shell /usr/local/pgsql/bin/pg_config --pgxs) Yet the results get definitions that try to pull in the regular install: # makefile (from `/r3/usr_local/pgsql/lib/pgxs/src/makefiles/../../src/Makefile.global', line 126) includedir := /usr/include/postgresql And it doesn't even get those right anyways: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -g -fpic -I. -I/usr/include/postgresql/server -I/usr/include/postgresql/internal -D_GNU_SOURCE -c -o test.o test.c -MMD test.c:19:22: error: postgres.h: No such file or directory test.c:20:18: error: fmgr.h: No such file or directory test.c:21:28: error: libpq/pqformat.h: No such file or directory test.c:22:28: error: utils/memutils.h: No such file or directory It seems like the point of pgxs is precisely to find the correct locations for these files. If it only works with standard locations then we could just hard code them in Makefiles. So I'm pretty sure this is supposed to work. What could I be doing wrong? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend