Re: ROLLBACK in a function?

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ROLLBACK in a function?
Date: 2003-05-29 12:23:01
Message-ID: m3r86irlga.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ruben 2003-05-29 12:24:16 Postmaster only takes 4-5% CPU
Previous Message pginfo 2003-05-29 11:17:59 URGENT: how to restore corrupted pg?