Skip site navigation (1) Skip section navigation (2)

Re: create constraint trigger

From: Kyle Bateman <kyle(at)actarg(dot)com>
To: JanWieck(at)Yahoo(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: create constraint trigger
Date: 2000-05-31 19:56:07
Message-ID: 39356E57.BCB3A1D5@actarg.com (view raw or flat)
Thread:
Lists: pgsql-sql
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


Attachment: kyle.vcf
Description: text/x-vcard (291 bytes)

In response to

pgsql-sql by date

Next:From: Mike MascariDate: 2000-05-31 23:32:40
Subject: Re: TOP SESSIONS?
Previous:From: Peter EisentrautDate: 2000-05-31 19:35:01
Subject: Re: create view security

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group