Re: Database Insertion commitment - Mailing list pgsql-general

From Ragnar
Subject Re: Database Insertion commitment
Date
Msg-id 1183971096.5778.55.camel@localhost.localdomain
Whole thread Raw
In response to Re: Database Insertion commitment  (Viatcheslav Kalinin <vka@ipcb.net>)
List pgsql-general
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 single separate transaction

this is not correct.

functions run in the transaction where they were called,
not in a separate one.

gnari



pgsql-general by date:

Previous
From: Gerhard Hintermayer
Date:
Subject: Re: ERROR: unexpected hash relation size:
Next
From: Viatcheslav Kalinin
Date:
Subject: Re: Database Insertion commitment