Re: Triggers - Mailing list pgsql-novice

From A.Bhuvaneswaran
Subject Re: Triggers
Date
Msg-id Pine.LNX.4.44.0304082101220.4365-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Triggers  (Ben Clewett <B.Clewett@roadrunner.uk.com>)
List pgsql-novice
> I want to have a go at some Triggers.  To update summary records of
> accounting data.
>
> I see in the reference manual
> http://www.de.postgresql.org/users-lounge/docs/7.2/postgres/sql-createconstraint.html
> it makes the comment:
>
> "It is not intended for general use."

postgres uses CREATE CONSTRAINT TRIGGER to create FK references during
pg_dump process. CREATE TRIGGER is what you are looking for.

regards,
bhuvaneswaran


pgsql-novice by date:

Previous
From: Antti Haapala
Date:
Subject: Re: operator '~~' for types 'inet' and '"unknown"'
Next
From: Josh Berkus
Date:
Subject: Re: Triggers