Thread: Trigger

Trigger

From
Raigo Lukk
Date:
Hi

I am trying to create a trigger for a detail table to check that value
what
 is entered exists in master table.
For example into CustomerOrder table could not be enterd order for
Customer what does not exists.

How is it best done in PostgreSQL?

I believe a trigger is what I must do.
I looked the documentation in the part of triggers and there was an
example what had a part:
execute procedure procedurename
Does this mean that I should create a procedure for each trigger?
Going further I found no Create Procedure in the documentation ... so how
to create procedures in PostgreSQL?


Thanks
Raigo
raigo.lukk@ttu.ee