- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 7 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 5 mois
- AWS OFFICIELA mis à jour il y a un an
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/