[jira] [Created] (MADLIB-1275) dev-check user doesn't have right privilege to create/drop table

[Jingyi Mei (JIRA)]

Jingyi Mei created MADLIB-1275:
----------------------------------

             Summary: dev-check user doesn't have right privilege to 
create/drop table 
                 Key: MADLIB-1275
                 URL: https://issues.apache.org/jira/browse/MADLIB-1275
             Project: Apache MADlib
          Issue Type: Bug
          Components: Madpack
            Reporter: Jingyi Mei


Repro:
login to your database
{code:java}
set search_path=madlib,public,"$user";{code}
manually create a table "vertex":
{code:java}
DROP TABLE IF EXISTS vertex, "EDGE";
CREATE TABLE vertex(
id INTEGER
);
INSERT INTO vertex VALUES
(0),
(1),
(2),
(3),
(4),
(5),
(6);{code}
Then run dev-check for pagerank:
{code:java}
./src/bin/madpack -p greenplum -c /madlib dev-check -t graph/pagerank{code}
 

Then it will fail and here is the error message:
{code:java}
DROP TABLE IF EXISTS vertex, "EDGE";
28 psql:/tmp/madlib.Ph19IE/graph/pagerank.sql_in.tmp:28: ERROR: must be owner 
of relation vertex{code}

Cause:

When running Install/Dev check, madpack will set 
{code:java}
SET search_path=madlib_installcheck_graph,madlib;{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)