K krooney Member Jun 18, 2018 176 16 18 Oct 12, 2020 #1 Hi Every time i upgrade schema always shows this Schema ALTER TABLE v_groups RENAME COLUMN group_order to group_level it never goes away even if I run upgrade a second time.Is there a way to fix this. Thanks in advanced!
Hi Every time i upgrade schema always shows this Schema ALTER TABLE v_groups RENAME COLUMN group_order to group_level it never goes away even if I run upgrade a second time.Is there a way to fix this. Thanks in advanced!
DigitalDaz Administrator Staff member Sep 29, 2016 3,089 588 113 Oct 12, 2020 #2 Run the command manually in postgres cli
K krooney Member Jun 18, 2018 176 16 18 Oct 12, 2020 #3 I will give that a try I just put it as is ALTER TABLE v_groups RENAME COLUMN group_order to group_level
I will give that a try I just put it as is ALTER TABLE v_groups RENAME COLUMN group_order to group_level
DigitalDaz Administrator Staff member Sep 29, 2016 3,089 588 113 Oct 12, 2020 #4 Yep, and see what it says
K krooney Member Jun 18, 2018 176 16 18 Oct 12, 2020 #5 sorry for my ignorance i enter postgres cli by typing su postgres in ssh
K krooney Member Jun 18, 2018 176 16 18 Oct 12, 2020 #6 this is the answer i get Bad Request [400] SQLSTATE[42701]: Duplicate column: 7 ERROR: column "group_level" of relation "v_groups" already exists
this is the answer i get Bad Request [400] SQLSTATE[42701]: Duplicate column: 7 ERROR: column "group_level" of relation "v_groups" already exists
