At 05:24 PM 18/07/2003 +0200, Reinoud van Leeuwen wrote:
Does anyone have a clue what is going wrong? I use Postgresql 7.3.3 on
FreeBSD 4.5.
Is it a before or after trigger. If 'before', are you trying to reference
data that does not exist yet?
--
On Fri, 2003-07-18 at 11:24, Reinoud van Leeuwen wrote:
> I'm debugging a trigger in plpgsql and for some reason or the "select
> into " does not seem to work. Here is an unaltered snippet of my
> trigger code:
>
>raise notice ''this id : %'',NEW.id;
>
>select into i_
I'm debugging a trigger in plpgsql and for some reason or the "select
into " does not seem to work. Here is an unaltered snippet of my
trigger code:
raise notice ''this id : %'',NEW.id;
select into i_hierarchy_id
hierarchy_id
from link_def LD,
