From: Kyle Bateman <kyle@actarg.com>
To: JanWieck@Yahoo.com
Cc: pgsql-sql@postgresql.org
Subject: Re: create constraint trigger
Date: Wed, 31 May 2000 13:56:07 -0600
Message-ID: <39356E57.BCB3A1D5@actarg.com> (raw)
References: <39330791.64796672@actarg.com>
Kyle Bateman wrote:
> Hi Jan:
>
> But when I create it with "create constraint trigger" as shown next,
> the trigger doesn't seem to be invoked. It says it is created, but it
> allows data to pass that would not be allowed with the "create
> trigger." So I'm assuming I'm doing something wrong.
>
> create constraint trigger prd_part_tr_iu after insert or update on
> prd_parm
> deferrable initially deferred
> for each row execute procedure prd_parm_tf_iu();
OK, here's a reply to my own post. I've got the constraint trigger
working now. The problem was that it was never getting dropped. I
still don't know how to drop the constraint. I thought by dropping the
trigger function it would get the idea. When I ran the create
constraint again, it said it was created (no errors) so I figured
everything was OK, but it was still running the previously defined
constraint (apparently).
I dropped the table and started from scratch and it seems to work fine
now.
So is there a way to "drop constraint trigger" without having to drop
the table?
Kyle
Attachments:kyle.vcf (text/x-vcard, 290B) download
begin:vcard
n:Bateman;Kyle
tel;fax:801-377-8096
tel;work:801-377-8033x101
x-mozilla-html:FALSE
url:www.actiontarget.com
org:Action Target Inc
adr:;;PO Box 636;Provo;UT;84603;US
version:2.1
email;internet:kyle@actiontarget.com
title:President
x-mozilla-cpt:;-15520
fn:Kyle Bateman
end:vcard
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-sql@postgresql.org
Cc: kyle@actarg.com, JanWieck@Yahoo.com
Subject: Re: create constraint trigger
In-Reply-To: <39356E57.BCB3A1D5@actarg.com>
References: <39330791.64796672@actarg.com> <39356E57.BCB3A1D5@actarg.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