Re: BUG #14825: enum type: unsafe use?
Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
From: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: balazs@obiserver.hu, pgsql-bugs@postgresql.org,
pgsql-hackers@postgresql.org
Date: 2017-09-25T14:24:53Z
Lists: pgsql-bugs, pgsql-hackers
On 09/25/2017 10:14 AM, Tom Lane wrote: > Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes: >> On 09/24/2017 07:06 PM, Tom Lane wrote: >>> So I think we should just stop with the blacklist test for v10, >>> and then see if we still get complaints (and exactly what they're >>> about) so that we can judge how much more work the problem deserves. >>> It's still ahead of where we were in previous releases, and ahead of >>> where we'd be if we end up reverting the patch altogether. >> That's pretty much what I was saying. > Oh ... I did not think we were on the same page, because your patch > didn't include removal of the same-transaction heuristic. It'd be > sensible to do that as a separate patch, though, to make it easier > to put back if we decide we do want it. > > I understood you to say that the blacklist patch was all we needed to do for v10. That's my position, i.e. I think we can live with the heuristic test for now if the blacklist patch is applied. Maybe we need to document that the heuristic test can generate some false negatives when testing for a type that is created in the current transaction. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Revert to 9.6 treatment of ALTER TYPE enumtype ADD VALUE.
- 28e072707685 11.0 landed
- 93a1af0b3f63 10.0 landed
-
Remove heuristic same-transaction test from check_safe_enum_use().
- 01c5de88ff24 10.0 landed
- 984c92074d84 11.0 landed
-
Use a blacklist to distinguish original from add-on enum values.
- 175774d2932d 10.0 landed
- 1635e80d30b1 11.0 landed
-
Add support for coordinating record typmods among parallel workers.
- cc5f81366c36 11.0 cited