Constraint type "Values that are generated by the database"???

Moderator: NorbertKrupa

Post Reply
User avatar
becky
Intermediate
Intermediate
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

Constraint type "Values that are generated by the database"???

Post by becky » Tue Mar 10, 2015 11:28 pm

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?
THANKS - BECKSTER

NorbertKrupa
GURU
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"???

Post by NorbertKrupa » Wed Mar 11, 2015 1:59 am

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.
Checkout vertica.tips for more Vertica resources.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Constraint type "Values that are generated by the database"???

Post by JimKnicely » Wed Mar 11, 2015 1:31 pm

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 8-) 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

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

User avatar
becky
Intermediate
Intermediate
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

Re: Constraint type "Values that are generated by the database"???

Post by becky » Wed Mar 11, 2015 6:25 pm

Again, thanks norbertk and Jim! Great great info. :!:
THANKS - BECKSTER

Post Reply

Return to “Vertica Database Administration”