Answer the question
In order to leave comments, you need to log in
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)
)
;
comment on column um.um_users.first_name
is 'Фамилия';
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
Answer the question
In order to leave comments, you need to log in
What will happen if you do
comment on column um_users.first_name
is 'Фамилия';
? Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question