I am working actually in an replication project. I need a trigger function but when I compile this, the C compilator
returnthe log message:
# cc -fpic -c main.c
In file included from /usr/include/postgresql/postgres.h:49,
from main.c:1:
/usr/include/postgresql/utils/elog.h:68:28: error: utils/errcodes.h: The file or directory does not exist
In file included from /usr/include/postgresql/8.3/server/funcapi.h:20,
from main.c:2:
/usr/include/postgresql/8.3/server/access/tupdesc.h:17:27: error: access/attnum.h: The file or directory does not exist
/usr/include/postgresql/8.3/server/access/tupdesc.h:18:34: error: catalog/pg_attribute.h: The file or directory does
notexist
/usr/include/postgresql/8.3/server/access/tupdesc.h:19:27: error: nodes/pg_list.h: No existe The file or directory does
notexist
In file included from /usr/include/postgresql/8.3/server/funcapi.h:20,
from main.c:2:
/usr/include/postgresql/8.3/server/access/tupdesc.h:24: error: expected specifier-qualifier-list before ‘AttrNumber’
/usr/include/postgresql/8.3/server/access/tupdesc.h:72: error: expected specifier-qualifier-list before
‘Form_pg_attribute’
/usr/include/postgresql/8.3/server/access/tupdesc.h:85: error: expected declaration specifiers or ‘...’ before
‘Form_pg_attribute’
.................
But the files exists in the indicated locations, any idea??
My plataform is Debian GNU/Linux, the headers files of postgresql-server-dev-8.3 are under
/usr/include/postgresql/8.3/server/,my haders files are:
#include <postgresql/8.3/server/postgres.h>
#include <postgresql/8.3/server/executor/spi.h>
#include <postgresql/8.3/server/commands/trigger.h>