From the docs I see that Vertica 7 supports the constraint types:
- c — check is reserved, but not supported
f - foreign
n - not null
p - primary
u - unique
d - determines
Moderator: NorbertKrupa
Code: Select all
dbadmin=> create table test (a int, b int, c int primary key);
CREATE TABLE
dbadmin=> alter table test add constraint t_cor correlation (b) determines (a);
ALTER TABLE
dbadmin=> select constraint_name, table_name, constraint_type from table_constraints where table_name = 'test';
constraint_name | table_name | constraint_type
-----------------+------------+-----------------
C_PRIMARY | test | p
t_cor | test | d
(2 rows)