On Tue, Oct 9, 2018 at 2:35 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > > That last part could *easily* change in a future release. We've > > already started to allow CTAS with parallel query, and there have > > already been multiple people wanting to allow more. It would be a > > shame if we threw up additional obstacles in the way of that... > > I hardly think that this is the most serious issue in the way of > doing non-read-only things in parallel workers.
My concern, as I said, is about adding new obstacles. > In any case, a parallel worker would surely have to open any > relations it is going to fire triggers for. If it gets the correct > lock when it does that, all is well. If not, the Assert in > relation_open will complain. Well, in that case, no issues. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
