Upgrading

[krooney]

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]

Run the command manually in postgres cli

 

[krooney]

I will give that a try
I just put it as is

ALTER TABLE v_groups RENAME COLUMN group_order to group_level

 

[DigitalDaz]

Yep, and see what it says

 

[krooney]

sorry for my ignorance

i enter postgres cli by typing su postgres in ssh

 

[krooney]

this is the answer i get

Bad Request [400]
SQLSTATE[42701]: Duplicate column: 7 ERROR: column "group_level" of relation "v_groups" already exists