/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 12676

schemas/util.sql: EXCEPTION blocks with multiple exception types: use OR to merge exception types into one WHEN block

     BEGIN
     	PERFORM util.eval(sql);
     EXCEPTION
     WHEN duplicate_table THEN NULL;
     WHEN duplicate_object THEN NULL; -- e.g. constraint
     WHEN duplicate_column THEN NULL;
     WHEN duplicate_function THEN NULL;
     WHEN   duplicate_table
     	OR duplicate_object -- eg. constraint
     	OR duplicate_column
     	OR duplicate_function
     THEN NULL;
     WHEN invalid_table_definition THEN
     	IF SQLERRM LIKE 'multiple primary keys for table % are not allowed' THEN NULL;
     	ELSE RAISE;
-...
     BEGIN
     	PERFORM util.eval(sql);
     EXCEPTION
     	/* trying to add NOT NULL column to parent table, which cascades to child
     	table whose values for the new column will be NULL */
     	WHEN not_null_violation THEN NULL;
     	WHEN wrong_object_type THEN NULL; -- trying to alter a view's columns
     	WHEN undefined_column THEN NULL;
     	WHEN duplicate_column THEN NULL;
     WHEN   not_null_violation
     		/* trying to add NOT NULL column to parent table, which cascades to
     		child table whose values for the new column will be NULL */
     	OR wrong_object_type -- trying to alter a view's columns
     	OR undefined_column
     	OR duplicate_column
     THEN NULL;
     END;
     $$;

Also available in: Unified diff