Postgres Pro
Downloads
Home   >   mailing lists

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

From Karsten Hilbert
Subject Re: ROLLBACK in a function?
Date
Msg-id 20030529114918.K1010@hermes.hilbert.loc
Whole thread Raw
In response to Re: ROLLBACK in a function?  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-general
Tree view 
> 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.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: ROLLBACK in a function?
Next
From: Jean-Michel POURE
Date:
Subject: pgAdmin3 snapshots