Thread: Transactions inside of pl/pgsql?

Transactions inside of pl/pgsql?

From
"Dr. Evil"
Date:
I'm write a bunch of pl/pgsql stored procedures.  I notice from the
documentation that you can't do SELECT FOR UPDATE from within a stored
pl/pgsql procedure.  Is this still true in 7.1?  Will it alwasy be
true?

Thanks

Re: Transactions inside of pl/pgsql?

From
Hiroshi Inoue
Date:
"Dr. Evil" wrote:
>
> I'm write a bunch of pl/pgsql stored procedures.  I notice from the
> documentation that you can't do SELECT FOR UPDATE from within a stored
> pl/pgsql procedure.  Is this still true in 7.1?  Will it alwasy be
> true?
>

You've been able to do it since 7.0.

regards,
Hiroshi Inoue