On Mon, Jul 29, 2019 at 9:48 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > I tried that first. There are backstops preventing doing LOCK TABLE > in a worker, just like for advisory locks. > > I believe the only accessible route to taking any sort of new lock > in a parallel worker is catalog lookups causing AccessShareLock on > a catalog.
Can't the worker just query a previously-untouched table, maybe by constructing a string and then using EXECUTE to execute it? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
