Re: Function Comit

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(at)agliodbs(dot)com>
To: "Aspire Something" <aspire420(at)hotpop(dot)com>; "pgsql-novice"
<pgsql-novice(at)postgresql(dot)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
>