From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
cc: Stephen Frost <sfrost@snowman.net>, Bruce Momjian <bruce@momjian.us>,
        "David E. Wheeler" <david@justatheory.com>,
        Christophe Pettus <christophe.pettus@pgexperts.com>,
        pgsql-bugs@postgresql.org, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] BUG #14825: enum type: unsafe use?
In-reply-to: <32160eb9-60df-746b-bbc0-dd232b993d6d@2ndQuadrant.com>
References: <27064.1506350579@sss.pgh.pa.us>
 <5f4f29bf-90b1-e49a-6cf9-069c59bc1067@2ndQuadrant.com>
 <40FDB1F3-932D-4912-B4C7-F1E26E331079@justatheory.com>
 <1090.1506365074@sss.pgh.pa.us> <9666.1506446327@sss.pgh.pa.us>
 <329.1506451066@sss.pgh.pa.us>
 <38835cdd-!c378-8d7a-013b-fd733c78c649@2ndQuadrant.com>
 <12792.1506456422@sss.pgh.pa.us> <20170926211419.GB7167@momjian.us>
 <16025.1506461535@sss.pgh.pa.us> <20170926214548.GQ4628@tamriel.snowman.net>
 <5161729c-4597-8a41-f4e2-c7d97e84d86e@2ndQuadrant.com>
 <32160eb9-60df-746b-bbc0-dd232b993d6d@2ndQuadrant.com>
Comments: In-reply-to Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
	message dated "Tue, 26 Sep 2017 18:18:53 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <10134.1506538374.1@sss.pgh.pa.us>
Date: Wed, 27 Sep 2017 14:52:54 -0400
Message-ID: <10135.1506538374@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
> At this stage on reflection I agree it should be pulled :-(

That seems to be the consensus, so I'll go make it happen.

> I'm not happy about the idea of marking an input function as not
> parallel safe, certainly not without a good deal of thought and
> discussion that we don't have time for this cycle.

I think the way forward is to do what we had as of HEAD (984c92074),
but add the ability to transmit the blacklist table to parallel
workers.  Since we expect the blacklist table would be empty most of
the time, this should be close to no overhead in practice.  I concur
that the idea of marking the relevant functions parallel-restricted is
probably not as safe a fix as I originally thought, and it's not a
very desirable restriction even if it did fix the problem.

			regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs