Re: Triggers

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Ben Clewett <B(dot)Clewett(at)roadrunner(dot)uk(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Triggers
Date: 2003-04-08 19:15:47
Message-ID: 200304081215.47612.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-novice

Ben,

> 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."
>
> Does this mean that there is a problem with triggers I should be aware of?

No, it means that you're in the wrong part of the documentation. You want
"CREATE TRIGGER" not "CREATE CONSTRAINT TRIGGER".

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

  • Triggers at 2003-04-08 13:30:51 from Ben Clewett

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Boes 2003-04-08 19:19:32 Re: pg_class.reltuples not reset by VACUUM?
Previous Message Tom Lane 2003-04-08 19:10:35 Re: pg_class.reltuples not reset by VACUUM?

Browse pgsql-novice by date

  From Date Subject
Next Message Molenda, Mark P 2003-04-08 19:24:17 Using asp.net
Previous Message A.Bhuvaneswaran 2003-04-08 15:33:01 Re: Triggers