RE: [GENERAL] Trigger

Switch to v7.0 beta1 and use FOREIGN KEY. You will save a lot of time.
Before you really finish your development there will be 7.0 production (this
is my private estimation).
Andrzej Mazurkiewicz

> -----Original Message-----
> From:    Raigo Lukk [SMTP:l950681@ttu.ee]
> Sent:    7 marca 2000 13:55
> To:    pgsql-general@postgreSQL.org
> Subject:    [GENERAL] Trigger
>
> 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
> trigger 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?
>
>
> Maybe, somebody could send me some example trigger for checking detail
> record value's existance in master table.
>
> Sorry, for simple question, but I just started using PostgreSQL.
>
>
> Thanks
> Raigo
> raigo.lukk@ttu.ee
>
>
> ************