From: Josh Berkus <josh@agliodbs.com>
To: Ben Clewett <B.Clewett@roadrunner.uk.com>
Cc: pgsql-novice <pgsql-novice@postgresql.org>
Subject: Re: Triggers
Date: Tue, 8 Apr 2003 12:15:47 -0700
Message-ID: <200304081215.47612.josh@agliodbs.com> (raw)
In-Reply-To: <3E92CF0B.50909@roadrunner.uk.com>
References: <Pine.LNX.4.44.0304081448010.1127-100000@Bhuvan.bksys.co.in>
<3E92C544.3040100@roadrunner.uk.com>
<3E92CF0B.50909@roadrunner.uk.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: josh@agliodbs.com, B.Clewett@roadrunner.uk.com, pgsql-novice@postgresql.org
Subject: Re: Triggers
In-Reply-To: <200304081215.47612.josh@agliodbs.com>
References: <Pine.LNX.4.44.0304081448010.1127-100000@Bhuvan.bksys.co.in> <3E92C544.3040100@roadrunner.uk.com> <3E92CF0B.50909@roadrunner.uk.com> <200304081215.47612.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox