Trigger

From: Raigo Lukk <l950681(at)ttu(dot)ee>
To: pgsql-general(at)hub(dot)org
Subject: Trigger
Date: 2000-03-07 12:49:42
Message-ID: Pine.GSO.4.10.10003071441110.874-100000@elo.va.ttu.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)lukk(at)ttu(dot)ee

Browse pgsql-general by date

  From Date Subject
Next Message Raigo Lukk 2000-03-07 12:54:56 Trigger
Previous Message Oleg Broytmann 2000-03-07 12:42:18 Re: [GENERAL] locale & mb support