Kris Kiger <kris@musicrebellion.com> writes:
> Interesting. That makes sense, though. So, is there a good way to lock
> a set of rows using SELECT FOR UPDATE in plpgsql? I assume using
> PERFORM would yield the same problem, because it immediately discards
> the results.
I think PERFORM would work. The fact that plpgsql ignores the results
doesn't mean you don't have lock on the rows.
regards, tom lane