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

Re: Tables and functions and triggers oh my...

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Fontenot, Paul" <Paul(dot)Fontenot(at)bannerhealth(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Tables and functions and triggers oh my...
Date: 2003-05-20 04:27:29
Message-ID: 3EC9AEB1.101@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-novice
Fontenot, Paul wrote:
> I'm going nuts, when I have this table/function/trigger combo my table
> never updates - works great as soon as I drop the trigger. Can someone
> not so green in PostgreSQL take a gander and tell me what I've done
> wrong?

[...snip...]

> textMessage := ''The PIX has generated the following: ''
> logRec.message '''';

The only thing I can see wrong is the above line. You probably want 
something like:

textMessage := ''The PIX has generated the following: '' || logRec.message;

or maybe:

textMessage := ''The PIX has generated the following: '''''' || 
logRec.message || '''''''';

HTH,

Joe



In response to

Responses

pgsql-novice by date

Next:From: Oliver ElphickDate: 2003-05-20 05:46:03
Subject: Re: 7.2.1 => 7.3.2
Previous:From: Fontenot, PaulDate: 2003-05-19 22:36:43
Subject: Tables and functions and triggers oh my...

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