Re: [ADMIN] creating and accessing temp table data inside a non-committed transaction

2011-01-31 Thread Leon Starr
Oops. Just noticed that I accidentally posted to the wrong group. I meant to put this in Novice! But thanks anyway! - Leon On Jan 31, 2011, at 7:42 AM, Kevin Grittner wrote: > Leon Starr wrote: > >> The problem is that the values x, y and z are inserted into a >> permanent table Q early in

Re: [ADMIN] creating and accessing temp table data inside a non-committed transaction

2011-01-31 Thread Leon Starr
Ah! That's what I had originally thought. So, if what you are saying is true, then I just have a bug of some sort. I am NOT using any triggers. It's just a simple function with deeper function calls nested about 5 levels down. To slightly rephrase: Any database changes (inserts/updates) made

Re: [ADMIN] creating and accessing temp table data inside a non-committed transaction

2011-01-31 Thread Kevin Grittner
Leon Starr wrote: > The problem is that the values x, y and z are inserted into a > permanent table Q early in the processing of my_func. Then, > several calls down in deep_func(), still inside my_func, I need to > access the value of x. I tried to do a select on Q to get the > value, but I ca