Start a new topic

Redshift Stored Procedure Nonatomic Mode

AWS Redshift stored procedures have an atomic and non-atomic mode, the default being atomic but you can add a keyword of NONATOMIC to the stored procedure definition.  Link below:


https://docs.aws.amazon.com/redshift/latest/dg/stored-procedure-transaction-management.html#stored-procedure-transaction-management-nonatomic-mode


In DBVisualizer, if you try to add the NONATOMIC keyword to the stored procedure and compile it, it erases the word and then compiles successfully.  Is there something i'm not doing right?  It doesn't seem to matter where you put the keyword either.  We are on the latest version of dbvisualizer. 


Any help would be greatly appreciated.  Thanks!

1 Comment

Hi Tim,

This looks like a shortcoming that we need to look into. I will register this and bring it up for discussion.
 
Thanks for taking the time to report it!

Kind regards, 
Peer
--
Peer Törngren
DbVis Software AB
Login or Signup to post a comment