N
N
Nikolay Baranenko2017-08-13 15:05:02
Database
Nikolay Baranenko, 2017-08-13 15:05:02

How to solve the problem of adding description to columns?

Hello.
I'm trying to add a description to the columns of a table in the Vertica database

create table um.um_users
(
id number,
first_name varchar2(50) not null,
last_name varchar2(50) not null,
password varchar2(50) not null,
last_login date,
username varchar2(50) not null,
role varchar2(50)
)
;

add comment
comment on column um.um_users.first_name 
is 'Фамилия';

and i get an error
SQL Error [2639] [42703]: [Vertica][VJDBC](2639) ROLLBACK: Column "um_users"."first_name" does not exist as a projection column
  [Vertica][VJDBC](2639) ROLLBACK: Column "um_users"."first_name" does not exist as a projection column
    com.vertica.util.ServerException: [Vertica][VJDBC](2639) ROLLBACK: Column "um_users"."first_name" does not exist as a projection column

How to solve it?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Kuznetsov, 2017-08-13
@drno-reg

What will happen if you do

comment on column um_users.first_name 
is 'Фамилия';
?
UPD. Have you seen this - www.vertica-forums.com/viewtopic.php?t=144 ? Apparently, this is your case.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question