On Jul 9, 2007, at 4:38 AM, Jasbinder Singh Bali wrote:
On 7/9/07, Viatcheslav Kalinin <[EMAIL PROTECTED]> wrote:
Jasbinder Singh Bali wrote:
>
> One reason I see that new insert does't see the values of old insert
> is because as soon as socket connection is established, my trigger
> returns an
On mán, 2007-07-09 at 05:22 -0400, Jasbinder Singh Bali wrote:
>
> The only difference between you test case my a sample test case that I
> would provide is the Perform part in the trigger function.
>
> In my program Perform part is about opening a socket connection with a
> Unix Tools server th
On 7/9/07, Viatcheslav Kalinin <[EMAIL PROTECTED]> wrote:
Jasbinder Singh Bali wrote:
>
> One reason I see that new insert does't see the values of old insert
> is because as soon as socket connection is established, my trigger
> returns and 1st insert is complete even though I'm not sure whethe
Jasbinder Singh Bali wrote:
One reason I see that new insert does't see the values of old insert
is because as soon as socket connection is established, my trigger
returns and 1st insert is complete even though I'm not sure whether
the unix tools server has already inserted values in table te
On 7/9/07, Viatcheslav Kalinin <[EMAIL PROTECTED]> wrote:
Jasbinder Singh Bali wrote:
> My scenario is something like this. I'll try to make it modular and
> simple.
>
> Start Function A (Written in plperlu with no subtransactions)
> Insert 1 on tbl_abc; (fires trigger A)
> Insert 2 on
On mán, 2007-07-09 at 03:34 -0400, Jasbinder Singh Bali wrote:
> My scenario is something like this. I'll try to make it modular and
> simple.
>
> Start Function A (Written in plperlu with no subtransactions)
> Insert 1 on tbl_abc; (fires trigger A)
> Insert 2 on tbl_abc; (fires trigger
Jasbinder Singh Bali wrote:
My scenario is something like this. I'll try to make it modular and
simple.
Start Function A (Written in plperlu with no subtransactions)
Insert 1 on tbl_abc; (fires trigger A)
Insert 2 on tbl_abc; (fires trigger A)
End Function A
Start Trigger A
ch
On mán, 2007-07-09 at 11:24 +0400, Viatcheslav Kalinin wrote:
> Jasbinder Singh Bali wrote:
> > If I have a series of Insert statements within a loop in a function on
> > the same table.
> > Would an Insert be able to see the values of previous insert in that
> > table ?
> Functions are run in a
My scenario is something like this. I'll try to make it modular and simple.
Start Function A (Written in plperlu with no subtransactions)
Insert 1 on tbl_abc; (fires trigger A)
Insert 2 on tbl_abc; (fires trigger A)
End Function A
Start Trigger A
check the value of col_abc in tbl_a
Jasbinder Singh Bali wrote:
Hi,
If I have a series of Insert statements within a loop in a function on
the same table.
Would an Insert be able to see the values of previous insert in that
table ?
I just wanted to know, when would the records be committed, as in, is
it after the whole function
am Mon, dem 09.07.2007, um 2:53:48 -0400 mailte Jasbinder Singh Bali
folgendes:
> Hi,
>
> If I have a series of Insert statements within a loop in a function on the
> same
> table.
> Would an Insert be able to see the values of previous insert in that table ?
Inside this function, yes. Outsid
Hi,
If I have a series of Insert statements within a loop in a function on the
same table.
Would an Insert be able to see the values of previous insert in that table ?
I just wanted to know, when would the records be committed, as in, is it
after the whole function is done for with its execution
12 matches
Mail list logo
