Skip site navigation (1) Skip section navigation (2)

Re: compilation error

From: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
To: Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>
Cc: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>, postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: compilation error
Date: 2009-08-26 11:27:16
Message-ID: c11950270908260427hc31bb96udfd9b73765a40e02@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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?

mydb=#

Thanks,
Jignesh
2009/8/25 Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>

>   aptitude search postgresql-server-dev-8.3
>
>
> Subject: Re: [NOVICE] compilation error
> To: "Devrim GÜNDÜZ" <devrim(at)gunduz(dot)org>
> Cc: "postgresql novice" <pgsql-novice(at)postgresql(dot)org>
> Date: Tuesday, August 25, 2009, 9:17 AM
>
>
>  Sorry but I dont know what is PostgreSQL development headers. Could you
> point me some links.
>
> Thanks a lot.
>
>
> 2009/8/25 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org<http://mc/compose?to=devrim(at)gunduz(dot)org>
> >
>
>> 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
>>
>> Install PostgreSQL development headers.
>> --
>> Devrim GÜNDÜZ, RHCE
>> Command Prompt - http://www.CommandPrompt.com<http://www.commandprompt.com/>
>> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
>>                   http://www.gunduz.org
>>
>
>
>
>
>

In response to

Responses

pgsql-novice by date

Next:From: Michael RowanDate: 2009-08-26 13:40:35
Subject: How to copy value between tables
Previous:From: Jignesh ShahDate: 2009-08-26 10:37:51
Subject: Re: Install new perl test function in PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group