- 最新
- 投票最多
- 评论最多
Currently there is no system table which exposes the NONATOMIC option. So you need access to your code base or privileges to view stored procedure code. There is a feature request to expose this information but it has not gathered much traction yet.
In Redshift, unlike PostgreSQL where parameter values are stored in a system table, the origin of each parameter value is categorized as "engine-default" or "user," indicating whether it has been altered.
Stored procedures in Redshift do not directly support the NONATOMIC option or the capability to adjust parameters using the SET command. Instead, configuration should be handled through the use of parameter groups, as mentioned earlier. For more information on Redshift parameter groups and an up-to-date list of parameters that can be configured, consult the AWS documentation.
相关内容
- AWS 官方已更新 2 年前
- AWS 官方已更新 5 个月前
- AWS 官方已更新 1 年前
- AWS 官方已更新 2 年前
Amazon Redshift announces support for auto-commit statements in stored procedure, also known as NONATOMIC mode in May 2023, refer the What's New post https://aws.amazon.com/about-aws/whats-new/2023/05/amazon-redshift-auto-commit-statements-stored-procedures/