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?
Constraint type "Values that are generated by the database"???
Moderator: NorbertKrupa
Constraint type "Values that are generated by the database"???
THANKS - BECKSTER
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Constraint type "Values that are generated by the database"???
I think it's referencing identity/sequences. Take a look at the column constraints. Vertica doesn't support CHECK constraints.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?
Checkout vertica.tips for more Vertica resources.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Constraint type "Values that are generated by the database"???
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
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
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Constraint type "Values that are generated by the database"???
Again, thanks norbertk and Jim! Great great info.
THANKS - BECKSTER