Creating a sequence without specifying a name?

Moderator: NorbertKrupa

Post Reply
User avatar
Josh
Intermediate
Intermediate
Posts: 106
Joined: Thu Jan 26, 2012 9:38 pm

Creating a sequence without specifying a name?

Post by Josh » Tue Mar 10, 2015 12:51 pm

In the Vertica SQL manual in the the CREATE SEQUENCE section it says "If you do not specify a sequence_name, HP Vertica assigns an internally generated name in the current schema."

Does anyone know what that means? I can't create a sequence without a name, and I can't think if any reason why you would want to anyway?!?!

Code: Select all

dbadmin=> create sequence;
ERROR 4856:  Syntax error at or near ";" at character 16
LINE 1: create sequence;
                       ^
Thank you!
Joshua

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Creating a sequence without specifying a name?

Post by NorbertKrupa » Tue Mar 10, 2015 6:11 pm

I'm trying to find out for you.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “New to Vertica Database Development”