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.
0