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

Re: Stored Procedure / Trigger Strangeness

From: Darren Ferguson <darren(at)crystalballinc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: laotse(at)lumberjack(dot)snurgle(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Stored Procedure / Trigger Strangeness
Date: 2001-12-21 16:03:01
Message-ID: Pine.LNX.4.10.10112211102210.17023-100000@thread.crystalballinc.com (view raw or flat)
Thread:
Lists: pgsql-general
If you need them to go in a specific order why not call one trigger and
have it call other functions not triggers and then you would get the
desired result


Darren

Darren Ferguson
Software Engineer
Openband

On Fri, 21 Dec 2001, Tom Lane wrote:

> laotse(at)lumberjack(dot)snurgle(dot)org writes:
> > ------------------------------------------------------------------ CREATE
> > TRIGGER fti_employee_lastname AFTER UPDATE OR INSERT OR DELETE ON person
> > FOR EACH ROW EXECUTE PROCEDURE fti(fti, lastname);
> 
> > CREATE TRIGGER fti_employee_firstname AFTER UPDATE OR INSERT OR DELETE ON
> > person FOR EACH ROW EXECUTE PROCEDURE fti(fti, firstname);
> 
> > CREATE TRIGGER fti_employee_screenname AFTER UPDATE OR INSERT OR DELETE ON
> > person FOR EACH ROW EXECUTE PROCEDURE fti(fti, screenname);
> 
> This will not work because there's no guarantee about the order of the
> execution of the triggers.  I haven't worked with fti much, but it's
> obvious that it expects you to have only *one* trigger relating a given
> indextable to the master --- on update, the trigger deletes all existing
> indextable rows for that master row.
> 
> It looks like the intended way to index multiple columns using a single
> indextable is
> 
> CREATE TRIGGER fti_person AFTER UPDATE OR INSERT OR DELETE ON person
> FOR EACH ROW EXECUTE PROCEDURE fti(fti, firstname, lastname, screenname);
> 
> Or you could use a separate indextable for each column, but that might
> not be what you want.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 


In response to

pgsql-general by date

Next:From: Joe KoenigDate: 2001-12-21 16:49:55
Subject: Is the Windows Version Stable?
Previous:From: laotseDate: 2001-12-21 15:47:00
Subject: Re: Stored Procedure / Trigger Strangeness

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