SENTRY-2333: Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH for Postgres only when it does not exist (Arjun Mishra reviewed by Na Li)
Change-Id: I69caafa59d902d3231576f177d38a513c09a39f5
diff --git a/sentry-provider/sentry-provider-db/src/main/resources/010-SENTRY-2210.postgres.sql b/sentry-provider/sentry-provider-db/src/main/resources/010-SENTRY-2210.postgres.sql
index cdc2ff7..bb77561 100644
--- a/sentry-provider/sentry-provider-db/src/main/resources/010-SENTRY-2210.postgres.sql
+++ b/sentry-provider/sentry-provider-db/src/main/resources/010-SENTRY-2210.postgres.sql
@@ -1,2 +1,11 @@
-- create index for foreign key AUTHZ_OBJ_ID
-CREATE INDEX "AUTHZ_PATH_FK_IDX" ON "AUTHZ_PATH" USING btree ("AUTHZ_OBJ_ID");
\ No newline at end of file
+DO $BLOCK$
+BEGIN
+ BEGIN
+ CREATE INDEX "AUTHZ_PATH_FK_IDX" ON "AUTHZ_PATH"( "AUTHZ_OBJ_ID" );
+ EXCEPTION
+ WHEN duplicate_table
+ THEN RAISE NOTICE 'index ''AUTHZ_PATH_FK_IDX '' on ''AUTHZ_PATH'' already exists, skipping';
+ END;
+END;
+$BLOCK$;
\ No newline at end of file
