[jira] [Commented] (SENTRY-2333) Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH for Postgres only when it does not exist
[
https://issues.apache.org/jira/browse/SENTRY-2333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16576831#comment-16576831
]
Hadoop QA commented on SENTRY-2333:
---
Here are the results of testing the latest attachment
https://issues.apache.org/jira/secure/attachment/12935160/SENTRY-2333.03.patch
against master.
{color:green}Overall:{color} +1 all checks pass
{color:green}SUCCESS:{color} all tests passed
Console output:
https://builds.apache.org/job/PreCommit-SENTRY-Build/4020/console
This message is automatically generated.
> Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH for Postgres only when it
> does not exist
> ---
>
> Key: SENTRY-2333
> URL: https://issues.apache.org/jira/browse/SENTRY-2333
> Project: Sentry
> Issue Type: Sub-task
> Components: Sentry
>Affects Versions: 2.1.0
>Reporter: Arjun Mishra
>Assignee: Arjun Mishra
>Priority: Major
> Attachments: SENTRY-2333.01.patch, SENTRY-2333.02.patch,
> SENTRY-2333.03.patch
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (SENTRY-2333) Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH for Postgres only when it does not exist
[
https://issues.apache.org/jira/browse/SENTRY-2333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16576797#comment-16576797
]
Hadoop QA commented on SENTRY-2333:
---
Here are the results of testing the latest attachment
https://issues.apache.org/jira/secure/attachment/12935161/SENTRY-2333.04.patch
against master.
{color:green}Overall:{color} +1 all checks pass
{color:green}SUCCESS:{color} all tests passed
Console output:
https://builds.apache.org/job/PreCommit-SENTRY-Build/4019/console
This message is automatically generated.
> Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH for Postgres only when it
> does not exist
> ---
>
> Key: SENTRY-2333
> URL: https://issues.apache.org/jira/browse/SENTRY-2333
> Project: Sentry
> Issue Type: Sub-task
> Components: Sentry
>Affects Versions: 2.1.0
>Reporter: Arjun Mishra
>Assignee: Arjun Mishra
>Priority: Major
> Attachments: SENTRY-2333.01.patch, SENTRY-2333.02.patch,
> SENTRY-2333.03.patch
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (SENTRY-2333) Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH for Postgres only when it does not exist
[
https://issues.apache.org/jira/browse/SENTRY-2333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16576585#comment-16576585
]
Arjun Mishra commented on SENTRY-2333:
--
Tested locally
{noformat}
postgres=> DO $BLOCK$
postgres$> BEGIN
postgres$> BEGIN
postgres$> CREATE INDEX "AUTHZ_PATH_FK_IDX" ON "AUTHZ_PATH"(
"AUTHZ_OBJ_ID" );
postgres$> EXCEPTION
postgres$> WHEN duplicate_table
postgres$> THEN RAISE NOTICE 'index ''AUTHZ_PATH_FK_IDX '' on
''AUTHZ_PATH'' already exists, skipping';
postgres$> END;
postgres$> END;
postgres$> $BLOCK$;
DO
postgres=> DO $BLOCK$
postgres$> BEGIN
postgres$> BEGIN
postgres$> CREATE INDEX "AUTHZ_PATH_FK_IDX" ON "AUTHZ_PATH"(
"AUTHZ_OBJ_ID" );
postgres$> EXCEPTION
postgres$> WHEN duplicate_table
postgres$> THEN RAISE NOTICE 'index ''AUTHZ_PATH_FK_IDX '' on
''AUTHZ_PATH'' already exists, skipping';
postgres$> END;
postgres$> END;
postgres$> $BLOCK$;
NOTICE: index 'AUTHZ_PATH_FK_IDX ' on 'AUTHZ_PATH' already exists, skipping
DO
postgres=> \d "AUTHZ_PATH"
Table "public.AUTHZ_PATH"
Column| Type | Collation | Nullable | Default
--+-+---+--+-
PATH_ID | bigint | | not null |
PATH_NAME| character varying(4000) | | |
AUTHZ_OBJ_ID | bigint | | |
Indexes:
"AUTHZ_PATH_PK" PRIMARY KEY, btree ("PATH_ID")
"AUTHZ_PATH_FK_IDX" btree ("AUTHZ_OBJ_ID")
Foreign-key constraints:
"AUTHZ_PATH_FK" FOREIGN KEY ("AUTHZ_OBJ_ID") REFERENCES
"AUTHZ_PATHS_MAPPING"("AUTHZ_OBJ_ID") DEFERRABLE
{noformat}
> Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH for Postgres only when it
> does not exist
> ---
>
> Key: SENTRY-2333
> URL: https://issues.apache.org/jira/browse/SENTRY-2333
> Project: Sentry
> Issue Type: Sub-task
> Components: Sentry
>Affects Versions: 2.1.0
>Reporter: Arjun Mishra
>Assignee: Arjun Mishra
>Priority: Major
> Attachments: SENTRY-2333.01.patch
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (SENTRY-2333) Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH for Postgres only when it does not exist
[
https://issues.apache.org/jira/browse/SENTRY-2333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16576562#comment-16576562
]
Hadoop QA commented on SENTRY-2333:
---
Here are the results of testing the latest attachment
https://issues.apache.org/jira/secure/attachment/12935155/SENTRY-2333.01.patch
against master.
{color:red}Overall:{color} -1 due to an error
{color:red}ERROR:{color} failed to build with patch (exit code 1)
Console output:
https://builds.apache.org/job/PreCommit-SENTRY-Build/4018/console
This message is automatically generated.
> Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH for Postgres only when it
> does not exist
> ---
>
> Key: SENTRY-2333
> URL: https://issues.apache.org/jira/browse/SENTRY-2333
> Project: Sentry
> Issue Type: Sub-task
> Components: Sentry
>Affects Versions: 2.1.0
>Reporter: Arjun Mishra
>Assignee: Arjun Mishra
>Priority: Major
> Attachments: SENTRY-2333.01.patch
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
