Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"

2019-11-05 Thread Fujii Masao
On Tue, Nov 5, 2019 at 11:19 PM Tom Lane wrote: > > Fujii Masao writes: > > I'm thinking to commit the patch. But I have one question; is it ok to > > back-patch? Since the patch changes the command tags for some commands, > > for example, which might break the existing event trigger functions >

Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"

2019-11-05 Thread Tom Lane
Fujii Masao writes: > I'm thinking to commit the patch. But I have one question; is it ok to > back-patch? Since the patch changes the command tags for some commands, > for example, which might break the existing event trigger functions > using TG_TAG if we back-patch it. Or we should guarantee

Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"

2019-11-04 Thread Fujii Masao
On Sat, Nov 2, 2019 at 4:40 PM Michael Paquier wrote: > > On Fri, Nov 01, 2019 at 02:17:03PM +0500, Ibrar Ahmed wrote: > > Do we really need a regression test cases for such small oversights? > > It is possible to get the command tags using an event trigger... But > that sounds hack-ish. Yes,

Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"

2019-11-02 Thread Michael Paquier
On Fri, Nov 01, 2019 at 02:17:03PM +0500, Ibrar Ahmed wrote: > Do we really need a regression test cases for such small oversights? It is possible to get the command tags using an event trigger... But that sounds hack-ish. -- Michael signature.asc Description: PGP signature

Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"

2019-11-01 Thread Ibrar Ahmed
On Fri, Nov 1, 2019 at 8:00 AM Fujii Masao wrote: > On Fri, Nov 1, 2019 at 6:34 AM Ibrar Ahmed wrote: > > > > > > > > On Thu, Oct 31, 2019 at 6:56 PM Tom Lane wrote: > >> > >> Fujii Masao writes: > >> > ... I found that the command tag

Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"

2019-10-31 Thread Fujii Masao
On Fri, Nov 1, 2019 at 6:34 AM Ibrar Ahmed wrote: > > > > On Thu, Oct 31, 2019 at 6:56 PM Tom Lane wrote: >> >> Fujii Masao writes: >> > ... I found that the command tag of >> > ALTER MATERIALIZED VIEW RENAME COLUMN is "ALTER TABLE", not "

Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"

2019-10-31 Thread Ibrar Ahmed
On Thu, Oct 31, 2019 at 6:56 PM Tom Lane wrote: > Fujii Masao writes: > > ... I found that the command tag of > > ALTER MATERIALIZED VIEW RENAME COLUMN is "ALTER TABLE", not "ALTER VIEW". > > > =# ALTER MATERIALIZED VIEW ho

Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"

2019-10-31 Thread Tom Lane
Fujii Masao writes: > ... I found that the command tag of > ALTER MATERIALIZED VIEW RENAME COLUMN is "ALTER TABLE", not "ALTER VIEW". > =# ALTER MATERIALIZED VIEW hoge RENAME COLUMN j TO x; > ALTER TABLE > Is this intentiona

The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"

2019-10-31 Thread Fujii Masao
LIZED VIEW =# ALTER MATERIALIZED VIEW test RENAME TO hoge; ALTER MATERIALIZED VIEW This is ok and looks intuitive to users. But I found that the command tag of ALTER MATERIALIZED VIEW RENAME COLUMN is "ALTER TABLE", not "ALTER VIEW". =# ALTER MATERIALIZED VIEW hoge RENAME