Re: modifying new tuple on insert in c trigger - Mailing list pgsql-general

From Doug McNaught
Subject Re: modifying new tuple on insert in c trigger
Date
Msg-id m3lm3ojqxs.fsf@varsoon.wireboard.com
Whole thread Raw
In response to modifying new tuple on insert in c trigger  ("Damjan Pipan" <damjan.pipan@siol.net>)
List pgsql-general
"Damjan Pipan" <damjan.pipan@siol.net> writes:

> Hello!
>
> I'm trying to write a c trigger function which would change an
> attribute of tuple being inserted. I have read this value
> from some other table and now I have a problem, because
> even if I change the tuple with SPI_modifytuple and return
> modified tuple it does not show in db (it did not change the tuple)
> but tuple is inserted.

Is it a BEFORE or AFTER trigger?  If it's modifying the inserted tuple
it needs to be BEFORE.

-Doug

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Bug with sequence
Next
From: Çagil Seker
Date:
Subject: Re: Bug with sequence