seahrh · January 29, 2021 08:23
diff --git a/redshift_exception_handling.sql b/redshift_exception_handling.sql
 CREATE OR REPLACE PROCEDURE sp_update_ddl()
 AS $$
 	BEGIN
 		alter table myschema.mytable add column newcolumn bigint;
 	EXCEPTION
 		WHEN OTHERS THEN
 			raise 'exception in filename.sql';
 	END
 $$ LANGUAGE plpgsql
 ;
	CREATE OR REPLACE PROCEDURE sp_update_ddl()
	AS $$
	BEGIN
	alter table myschema.mytable add column newcolumn bigint;
	EXCEPTION
	WHEN OTHERS THEN
	raise 'exception in filename.sql';
	END
	$$ LANGUAGE plpgsql
	;