On Tue, Oct 9, 2018 at 2:35 PM Tom Lane <tgl@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