Re: BUG #14825: enum type: unsafe use?
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Cc: balazs@obiserver.hu, pgsql-bugs@postgresql.org,
pgsql-hackers@postgresql.org
Date: 2017-09-25T14:42:59Z
Lists: pgsql-bugs, pgsql-hackers
Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes: > On 09/25/2017 10:14 AM, Tom Lane wrote: >> 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. No, as I said upthread, I want the heuristic out of there. I think the blacklist idea covers enough use-cases that we possibly don't need the same-transaction test at all. Furthermore I'm doubtful that the heuristic form of the same-transaction test is adequate to satisfy the use-cases that the blacklist test doesn't cover. So I think we should remove that test and see whether we get any complaints, and if so what the details of the real-world use-cases look like. regards, tom lane
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