From: Tulio Oliveira <mestredosmagos@marilia.com>
To: pgsql-sql@postgresql.org
Subject: Compiling "C" Functions
Date: Thu, 14 Dec 2000 16:05:43 -0200
Message-ID: <3A390BF7.71D0E481@marilia.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: mestredosmagos@marilia.com
Subject: Re: Compiling "C" Functions
In-Reply-To: <3A390BF7.71D0E481@marilia.com>
References: <3A390BF7.71D0E481@marilia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox