| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com> |
| Cc: | "David E(dot) Wheeler" <david(at)justatheory(dot)com>, Christophe Pettus <christophe(dot)pettus(at)pgexperts(dot)com>, pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: BUG #14825: enum type: unsafe use? |
| Date: | 2017-09-26 17:18:47 |
| Message-ID: | 9666.1506446327@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
I wrote:
> Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com> writes:
>> OK, that seems to be the consensus. So let's apply the blacklist patch
>> and then separately remove the 'created in the same transaction' test.
>> We'll need to adjust the regression tests and docs accordingly.
> Agreed. I'll work on that in a little bit.
Pushed; sorry for the delay.
I noticed that the blacklist mechanism effectively removed the prohibition
against using a renamed enum value later in the same transaction, so I
added a regression test for that. Also, as committed, I used RENAME TYPE
rather than ALTER OWNER in the test cases requiring an updated pg_type
row. That way we don't need to create a role, even a transient one, which
is a good thing in terms of not risking collisions with other sessions.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-09-26 18:17:21 | Re: BUG #14785: Logical replication does not work after adding a column. Bug? |
| Previous Message | Stephen Frost | 2017-09-26 16:00:58 | Re: BUG #14785: Logical replication does not work after adding a column. Bug? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Dilger | 2017-09-26 17:23:55 | md5 still listed as an option in pg_hba.conf.sample |
| Previous Message | Robert Haas | 2017-09-26 16:51:52 | Re: path toward faster partition pruning |