Search found 5 matches

by dougwwt
Thu Jun 07, 2018 5:08 pm
Forum: General
Topic: Primary Key Constraints
Replies: 8
Views: 155793

Re: Primary Key Constraints

Jim,
I tried sending you an email but it keeps coming back undeliverable. Will you please send me an email and I'll try to reply to it and see if that works.
by dougwwt
Mon Jun 04, 2018 7:09 pm
Forum: General
Topic: Primary Key Constraints
Replies: 8
Views: 155793

Re: Primary Key Constraints

I sent my examples to this email. I hope you received them.
by dougwwt
Fri Jun 01, 2018 9:35 pm
Forum: General
Topic: Primary Key Constraints
Replies: 8
Views: 155793

Re: Primary Key Constraints

Thanks Jim. Email sent.
by dougwwt
Tue May 29, 2018 1:35 pm
Forum: General
Topic: Primary Key Constraints
Replies: 8
Views: 155793

Re: Primary Key Constraints

Jim, I checked the projection table and both the unsegmented projection I created and the segmented projection that the system created have is_key_constraint_projection = 'true'. I checked both projections again and they are both on the exact same two fields. Below is the portion of code after I exp...
by dougwwt
Fri May 25, 2018 7:13 pm
Forum: General
Topic: Primary Key Constraints
Replies: 8
Views: 155793

Primary Key Constraints

I'm relatively new to Vertica. We are on Vertica 8.1. I'm going thru all our projections and figuring out if they should be segmented or unsegmented. We have some small tables that have primary key constraints. I made those primary key/unique key projections unsegmented but it looks like Vertica aut...

Go to advanced search