Compiling C Functions

Hi, ALL

This is my first time in this list... Sorry by any inconvenience....

I need a TRIGGER thats runs whith POSTGRES permissions. I�ll give an ODBC
connection for programmers that don�t need to know the "rules" of my Data
Base.

So, I�ll creata an "fake" table, and with a BEFORE INSERT TRIGGER I�ll make
all consistences, and update the REAL tables.

The ODBC users have only INSERT permission on the fake table, and NO RIGHTS
on the real table.

I�ll make VIEWS whith SELECT, UPDATE and DELETE permissions for the ODBC
users.

By the same way, I�ll make TRIGGERS that manager the VIEWS.

-----------

ALMOST ALL THIS WORK FINE when the function of the trigger is in PLPGSQL, but
in this language, the Trigger run with the same ODBD user�s rights ....

I read that only a "C" function runs with POSTGRES permissions, but all the
samples I get don�t work... I can�t even compile them...

Please, anyone could help an "poor brazilian guy" to make this work :-) ?

I appreciate any "C" Function complete samples, including de command line for
the compiler.

I using a RedHat Linux 6.2 and  Postgresql 7.0.2-2


Best Regards,

Tulio Oliveira.