Re: ROLLBACK in a function? - Mailing list pgsql-general

From Doug McNaught
Subject Re: ROLLBACK in a function?
Date
Msg-id m3r86irlga.fsf@varsoon.wireboard.com
Whole thread Raw
In response to ROLLBACK in a function?  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-general
Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:

> > BEGIN WORK
> >     select function ([params])
> [...]
> > END WORK
> No need to rollback/commit if you are dealing with SELECTs
> that don't have row modifying side effects.

Right, but SELECTing a function can do anything.  ;)

-Doug

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: how much does a connection cost?
Next
From: Ruben
Date:
Subject: Postmaster only takes 4-5% CPU