Compiling "C" Functions - Mailing list pgsql-sql

From Tulio Oliveira
Subject Compiling "C" Functions
Date
Msg-id 3A390BF7.71D0E481@marilia.com
Whole thread Raw
List pgsql-sql
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.





-- 
======================================================
AKACIA TECNOLOGIA
Desenvolvimento de sistemas para Internet
www.akacia.com.br


pgsql-sql by date:

Previous
From: "Franklin Vera"
Date:
Subject: Howto compile fti.c
Next
From:
Date:
Subject: pg_control error!