Archive | June, 2013

Adding a Column Check Constraint

Vertica does not support check constraints for table columns. There are some pretty darn good reasons for that! Probably the best reason is the fact that we want to load data into Vertica super fast. To do that Vertica ignores all constraints assuming we’ve already scrubbed the data we’re loading. So why introduce another hurdle? […]

Read more