/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 12568

schemas/util.sql: `RAISE USING ERRCODE = SQLSTATE, MESSAGE = SQLERRM`: use simpler `RAISE` to rethrow error

         WHEN duplicate_column THEN NULL;
         WHEN invalid_table_definition THEN
             IF SQLERRM LIKE 'multiple primary keys for table % are not allowed' THEN NULL;
             ELSE RAISE USING ERRCODE = SQLSTATE, MESSAGE = SQLERRM; -- rethrow
             ELSE RAISE;
             END IF;
     END;
     $$;
-...
     		WHEN array_subscript_error THEN -- selective suppress
     			IF SQLERRM LIKE 'arrays must have same bounds' THEN NULL;
     				-- metadata cols not yet added
     			ELSE RAISE USING ERRCODE = SQLSTATE, MESSAGE = SQLERRM; -- rethrow
     			ELSE RAISE;
     			END IF;
     	END;

Also available in: Unified diff