We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


CREATE SEQUENCE IF NOT EXISTS -- why not? — Vertica Forum

CREATE SEQUENCE IF NOT EXISTS -- why not?

Why does vertica conditionally dropping a sequence like this:

DROP SEQUENCE IF EXISTS <sequence_name>;

 

but it does not support conditional creation, like this?

 

CREATE SEQUENCE IF NOT EXISTS <sequence_name>;

Also, why is the conditional drop not documented anywhere in the most recent documentation online?  I'm curious whether this will be supported soon, or if neither is ever intended to be officially supported.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file