Transactions inside of pl/pgsql?

Started by Dr. Evilalmost 25 years ago2 messagesgeneral
Jump to latest
#1Dr. Evil
drevil@sidereal.kz

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

#2Hiroshi Inoue
Inoue@tpf.co.jp
In reply to: Dr. Evil (#1)
Re: Transactions inside of pl/pgsql?

"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