triggers

On Tue, 14 Aug 2001, Martin Kuria wrote:

Hi, I have a problem I am using postgresql database and I want to enforce

triggers between my related tables ( tables with relationship), one

table

has a foreign key and the other the a primary key, I would like to use
triggers to update, delete, and insert in this tables but the table with

the

foreign key should first check in the other table before any action is
taken, Which is the simplest sql or C language script can I use to

enforce

triggers within my tables, please demonstrate a simple scenerio thanks

pgsql-bugs is definately not the place for this message (response to
-general).

Since I can't tell what you're precisely trying to do from the
explanation above, the easiest starting point is to look at the
documentation for triggers and then at techdocs.postgresql.org for
a couple trigger examples.

However, I don't believe you can guarantee that the foreign key trigger is
going to happen before your trigger.