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?

Joseph_LeibaJoseph_Leiba
in General Discussion

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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...