Re: Function Comit - Mailing list pgsql-novice

From Aspire Something
Subject Re: Function Comit
Date
Msg-id 01c901c2de8b$a4aeba50$c9c832c0@societykotla
Whole thread Raw
In response to Function Comit  ("Aspire Something" <aspire420@hotpop.com>)
Responses Re: Function Comit
List pgsql-novice
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
>


pgsql-novice by date:

Previous
From: "Warren Massengill"
Date:
Subject: initdb "file not found"
Next
From: Bill Colls
Date:
Subject: Re: initdb "file not found"