The Vertica Database Forums

Me again

I have another question about constraints. The Admin Guide mentions a constraint type "Values that are generated by the database". What is that?

Here is the link:

http://my.vertica.com/docs/7.1.x/HTML/i ... nts|_____0

Another thing, the same page says "Some examples of constraints are:" and then lists the constraints. If this is only "some" of them, what are the other ones? Are they undocumented?

becky wrote:Me again

I have another question about constraints. The Admin Guide mentions a constraint type "Values that are generated by the database". What is that?

Here is the link:

http://my.vertica.com/docs/7.1.x/HTML/i ... nts|_____0

Another thing, the same page says "Some examples of constraints are:" and then lists the constraints. If this is only "some" of them, what are the other ones? Are they undocumented?

I think it's referencing identity/sequences. Take a look at the column constraints. Vertica doesn't support CHECK constraints.

There is the "Determines" constraint:

http://www.vertica-forums.com/viewtopic ... 869&p=6193

For fun, here are some older topics on how to fake a "Check" constraints in Vertica But, I wouldn't recommend implementing any of these in a production system...

http://www.vertica-forums.com/viewtopic.php?f=67&t=1091
http://www.vertica-forums.com/viewtopic.php?f=48&t=920
http://www.vertica-forums.com/viewtopic.php?f=48&t=336

Again, thanks norbertk and Jim! Great great info.