Sender: teo@flex.flex.ro
Message-ID: <38AAAD16.C05F47C3@flex.ro>
Date: Wed, 16 Feb 2000 15:58:46 +0200
From: Constantin Teodorescu <teo@flex.ro>
MIME-Version: 1.0
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: A question on triggers
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have two tables "inputs" and "outputs" and they hold items and
quantities that are coming and going from a warehouse.

I have defined also another table "stock" that will hold the inventory
of that warehouse.

I have defined triggers on INSERT, UPDATE and DELETE on "inputs" and
"outputs" tables that update acordingly the "stock" table!

What's my problem?

Is there any chance to restrict the direct updates of any user to the
"stock" table?
So that the information in the "stock" table should be updated ONLY by
those triggers?

Thanks in advance,

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA