pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (2+ messages)

Message-ID: <39356E57.BCB3A1D5@actarg.com>
Permalink:  ../39356E57.BCB3A1D5@actarg.com/
Also on:    postgresql.org/message-id/39356E57.BCB3A1D5@actarg.com

 · 

reply

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