To: "Lennin Caro" <lennin.caro@yahoo.com> Cc: "Devrim GÜNDÜZ" <devrim@gunduz.org>, "postgresql novice" <pgsql-novice@postgresql.org> Date: Wednesday, August 26, 2009, 11:27 AM
Lennin, I could see language C installed in database then also I will need to install postgresql-server-dev-8.3?
mydb=> SELECT * FROM pg_language; lanname | lanowner | lanispl | lanpltrusted | lanplcallfoid | lanvalidator | lanacl ----------+----------+---------+--------------+---------------+--------------+-------- internal | 10 | f | f | 0 | 2246 | c | 10 | f | f | 0 | 2247 | sql | 10 | f | t | 0 | 2248 | plperl | 16386 | t | t | 19193 | 19194 |
Do I need to compile C trigger from the PostgrSQL server or from the my database connection? I mean I do ssh to my unix server where I have PostgreSQL configured. From here I should compile? OR should I compile code from below mydb database connection?
On Tue, 2009-08-25 at 13:46 +0530, Jignesh Shah wrote: > > # gcc -fpic -c masanip-test-trigger.c
> test-trigger.c:1:22: error: postgres.h: No such file or directory > test-trigger.c:2:77: error: executor/spi.h: No such file or directory > test-trigger.c:3:55: error: commands/trigger.h: No such file or > directory
