Thanks for pointers, that has cleared a few things up for me.
On 03/07/2008, at 11:27 PM, Csaba Nagy wrote:
On Thu, 2008-07-03 at 23:15 +1000, Aaron Spiteri wrote:
Inside foo there was a INSERT and UPDATE, and the INSERT failed but
the UPDATE succeeded would the UPDATE be rolled back?
Just t
On Thu, 2008-07-03 at 23:15 +1000, Aaron Spiteri wrote:
> Inside foo there was a INSERT and UPDATE, and the INSERT failed but
> the UPDATE succeeded would the UPDATE be rolled back?
Just to add to the other answers, if the INSERT is before the UPDATE in
the function, the function execution stops
am Thu, dem 03.07.2008, um 23:15:33 +1000 mailte Aaron Spiteri folgendes:
> Hi guys,
>
> I have been following the mailing list and reading the source code
> for a little while, and was wandering if someone could fill in the
> gaps for me. Does PostgresQL view updates and inserts performed
Hi guys,
I have been following the mailing list and reading the source code
for a little while, and was wandering if someone could fill in the
gaps for me. Does PostgresQL view updates and inserts performed in a
function as part of the same transaction or are they considered
separate tr