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

Strange trigger behaviour

From: "P(dot)V(dot) Subramanian" <pvsmian(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Strange trigger behaviour
Date: 2001-09-23 04:46:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

I have a trigger function (C shared library) thats supposed to get called 

The called function needs to read the record that was just added (which 
resulted in the function call)

However, this function doesn't seem to see the latest record added. Its as 
if the INSERT never completed, during the life of the function.

Of course, a SELECT * shows that the record did get added.

And the function sees all the other older records in the table.

What should I do?

(And, why dont my elog notices not show up on the screen? That would have 
helped me debug a bit)

Thanks in advance


Get your FREE download of MSN Explorer at

pgsql-novice by date

Next:From: WIERS,FREDERIK (HP-Netherlands,ex1)Date: 2001-09-24 12:29:04
Subject: Varchar and multi-byte
Previous:From: Matthew BraithwaiteDate: 2001-09-22 20:40:15
Subject: Index not used for simple query, and yes I ran vacuum analyze

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