Question about accessing current row data inside trigger

peter Willis · *nix forums beginner Joined: 08 Mar 2005 Posts: 3

Hello,

I have a trigger function written in C.
The trigger function is called via:

CREATE TRIGGER after_update AFTER UPDATE ON some_table
FOR EACH ROW EXECUTE PROCEDURE my_trigger_function();

Since the trigger is called after each row update the actual row data
should be available in some way to the trigger.
What functionality (SPI ?) do I use to use the column values from
the current row in the actual trigger?

thanks for any insight,

Peter

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Michael Fuhr · *nix forums Guru Joined: 02 Mar 2005 Posts: 674

On Tue, Mar 08, 2005 at 11:37:14AM -0800, peter Willis wrote:

Tom Lane · *nix forums Guru Joined: 24 Mar 2005 Posts: 2070

peter Willis <peterw@borstad.com> writes:

peter Willis · *nix forums beginner Joined: 08 Mar 2005 Posts: 3

Hello,

I resolved this issue already.
The trigger now works fine.
I was looking at the wrong structure.

Thanks,

Peter

Michael Fuhr wrote:

peter Willis · *nix forums beginner Joined: 08 Mar 2005 Posts: 3

Hello,

This issue is resolved.
I was using the wrong struct.

Peter

Tom Lane wrote:

Google