On Fri, Aug 1, 2008 at 11:02 AM, EXT-Rothermel, Peter M
<[EMAIL PROTECTED]> wrote:
>
> I was thinking of something like this:
>
> connect to DB
>
> BEGIN
>
> SELECT * FROM table_foo where foo_state = 'queued' FOR UPDATE;
> for each row
> do [
>
>SAVEPOINT s;
>UPDATE foo_resource SET in_use
I have a client application that needs:
SELECT a set of records from a table and lock them for potential
updates.
for each record
make some updates to this record and some other records in other
tables
call some call a function that does some application logic that
does not access the da
> Does PostgreSQL currently support something like savepoints in Oracle?
No, sorry, but we know we need them.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+
Does PostgreSQL currently support something like savepoints in Oracle?
Hans
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
