/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 12595

schemas/util.sql: create_if_not_exists(): also support `CREATE FUNCTION` (by handling duplicate_function exceptions)

         LANGUAGE plpgsql STRICT
         AS $$
     BEGIN
         PERFORM util.eval(sql);
     	PERFORM util.eval(sql);
     EXCEPTION
         WHEN duplicate_table  THEN NULL;
         WHEN duplicate_object THEN NULL; -- e.g. constraint
         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;
             END IF;
     WHEN duplicate_table THEN NULL;
     WHEN duplicate_object THEN NULL; -- e.g. constraint
     WHEN duplicate_column THEN NULL;
     WHEN duplicate_function THEN NULL;
     WHEN invalid_table_definition THEN
     	IF SQLERRM LIKE 'multiple primary keys for table % are not allowed' THEN NULL;
     	ELSE RAISE;
     	END IF;
     END;
     $$;

Also available in: Unified diff