v.24.10Improvement
Support for Atomic CREATE OR REPLACE VIEW
Why it matters
This feature allows users to atomically create or replace a view, ensuring that the operation is done safely without intermediate inconsistent states. It simplifies view management and reduces the risk of errors when updating views.How to use it
Users can use theCREATE OR REPLACE VIEW syntax in their SQL queries to create a new view or replace an existing one atomically. For example:CREATE OR REPLACE VIEW view_name AS
SELECT ... FROM ...;