Re: pgsql: Ensure correct lock level is used in ALTER ... RENAME

2021-10-20 Thread Alvaro Herrera
Hi, On 2021-Oct-20, Michael Paquier wrote: > hippopotamus and jay are complaining that this commit has introduced a > test with ordering issues: > ORDER BY relation::regclass::text; Oh, I forgot that we need a COLLATE clause there. Will fix, thanks ... -- Álvaro Herrera Valdivi

Re: pgsql: Ensure correct lock level is used in ALTER ... RENAME

2021-10-20 Thread Michael Paquier
Hi Alvaro, On Tue, Oct 19, 2021 at 10:11:24PM +, Alvaro Herrera wrote: > Ensure correct lock level is used in ALTER ... RENAME > > Commit 1b5d797cd4f7 intended to relax the lock level used to rename > indexes, but inadvertently allowed *any* relation to be renamed with a > lowered lock level,

pgsql: Ensure correct lock level is used in ALTER ... RENAME

2021-10-19 Thread Alvaro Herrera
Ensure correct lock level is used in ALTER ... RENAME Commit 1b5d797cd4f7 intended to relax the lock level used to rename indexes, but inadvertently allowed *any* relation to be renamed with a lowered lock level, as long as the command is spelled ALTER INDEX. That's undesirable for other relation

pgsql: Ensure correct lock level is used in ALTER ... RENAME

2021-10-19 Thread Alvaro Herrera
Ensure correct lock level is used in ALTER ... RENAME Commit 1b5d797cd4f7 intended to relax the lock level used to rename indexes, but inadvertently allowed *any* relation to be renamed with a lowered lock level, as long as the command is spelled ALTER INDEX. That's undesirable for other relation

pgsql: Ensure correct lock level is used in ALTER ... RENAME

2021-10-19 Thread Alvaro Herrera
Ensure correct lock level is used in ALTER ... RENAME Commit 1b5d797cd4f7 intended to relax the lock level used to rename indexes, but inadvertently allowed *any* relation to be renamed with a lowered lock level, as long as the command is spelled ALTER INDEX. That's undesirable for other relation

pgsql: Ensure correct lock level is used in ALTER ... RENAME

2021-10-19 Thread Alvaro Herrera
Ensure correct lock level is used in ALTER ... RENAME Commit 1b5d797cd4f7 intended to relax the lock level used to rename indexes, but inadvertently allowed *any* relation to be renamed with a lowered lock level, as long as the command is spelled ALTER INDEX. That's undesirable for other relation