Pavel Stehule wrote: > 2017-06-29 7:17 GMT+02:00 Yevhenii Kurtov <yevhenii.kurtov@xxxxxxxxx>: > > > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
