On mán, 2007-07-09 at 05:22 -0400, Jasbinder Singh Bali wrote: > > The only difference between you test case my a sample test case that I > would provide is the Perform part in the trigger function. > > In my program Perform part is about opening a socket connection with a > Unix Tools server that runs traceroute and populates records in table > test. then the inserts into table test are made in a separate transaction. > > One reason I see that new insert does't see the values of old insert > is because as soon as socket connection is established, my trigger > returns and 1st insert is complete even though I'm not sure whether > the unix tools server has already inserted values in table test or > not. There might be a time lag based on how fast traceroute returns, > though right now its very fast. you should be able to see the row if the tools server has committed before the next trigger fires gnari >
