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
> 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
+
