How to rename constraints

joergschaber

Hi,
is there a more simple or elegant way to rename table-contraints other than dropping and adding again?

marcothesane

if there were any ways to achieve that, @joergschaber, it would be an ALTER CONSTRAINT command. I tried both searching the docu and by firing this command:

marco ~/1/Vertica/supp $ vsql -c "ALTER CONSTRAINT l_c_pk RENAME TO pk-l_c"
ERROR 4856:  Syntax error at or near "CONSTRAINT" at character 7
LINE 1: ALTER CONSTRAINT l_c_pk RENAME TO pk-l_c