Dear Josh,
I dont think it is a bug !!!
Let me explain :
While we are working in the function func_1()
It calls func_2() and data reproduced is accesed by func_3()
diagramaticlly it is something like this
_____________________func_1()
|
|___ func_2()_____
| |
|_______________|__func_3()
|
|
end of func_1)
Here is the catch since func_1()'s block is not finisied any data will not
be reflected / commited in the database
untill succesfull completion of the func_1()
(This is what my intution say)
If I am wrong please and kindly revert back , mean while i am drafting a
sample set of functions, which is reproducable.
Regards,
V Kashyap
----- Original Message -----
From: "Josh Berkus" <josh@agliodbs.com>
To: "Aspire Something" <aspire420@hotpop.com>; "pgsql-novice"
<pgsql-novice@postgresql.org>
Sent: Thursday, February 27, 2003 10:45 PM
Subject: Re: [NOVICE] Function Comit
> Aspire,
>
> > Permit me to recive your geeky knowledge,
>
> <grin> Can I quote that?
>
> > Though it has been found func_3() does not work on the latest data
produced
> > by func_2() . Though on other hand if i exec function seperately (Ouside
> > func_1) func_3 does work on the latest data of func_2;
>
> Hmmm ... this may be related to a bug which Robert Treat reported a few
weeks
> ago. Can you provide a sample set of functions, which is reproducable, so
> that I can test this issue?
>
> --
> Josh Berkus
> Aglio Database Solutions
> San Francisco
>