Pavel Stehule wrote:
> 2017-06-29 7:17 GMT+02:00 Yevhenii Kurtov <yevhenii.kurtov@gmail.com>:
>
> > I just tried UNION queries and got following error:
> >
> > ERROR: FOR UPDATE is not allowed with UNION/INTERSECT/EXCEPT
>
> it is sad :(
I think we could lift this restriction for UNION ALL, but UNION sounds
difficult.
BTW I wonder how much of the original problem is caused by using a
prepared query. I understand the desire to avoid repeated planning
work, but I think in this case it may be working against you.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services