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@xxxxxxxxxxxx>
To: "Aspire Something" <aspire420@xxxxxxxxxx>; "pgsql-novice"
<pgsql-novice@xxxxxxxxxxxxxx>
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
>


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html