Re: Database Insertion commitment

From: Ragnar <gnari(at)hive(dot)is>
To: Viatcheslav Kalinin <vka(at)ipcb(dot)net>
Cc: Jasbinder Singh Bali <jsbali(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Database Insertion commitment
Date: 2007-07-09 08:51:36
Message-ID: 1183971096.5778.55.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Viatcheslav Kalinin 2007-07-09 08:53:38 Re: Database Insertion commitment
Previous Message Gerhard Hintermayer 2007-07-09 08:20:55 Re: ERROR: unexpected hash relation size: