[jira] [Commented] (HAWQ-1556) Support more statements with ALTER OWNER

["Kuien Liu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HAWQ-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16268664#comment-16268664 ] 

Kuien Liu commented on HAWQ-1556:
---------------------------------

I have done a quick-test, proved these feature (e.g., ALTER SCHEMA OWNER) can be supported well. I also prepared a UDF to change table's ownership as well as its schema's.

{{
postgres=# \dt kuien.
              List of relations
 Schema | Name | Type  | Owner |   Storage
--------+------+-------+-------+-------------
 kuien  | tb1  | table | admin | append only
 kuien  | tb2  | table | admin | append only
(2 rows)

postgres=# \dn kuien
List of schemas
 Name  | Owner
-------+-------
 kuien | admin
(1 row)

postgres=# \dg kuien
            List of roles
 Role name |  Attributes  | Member of
-----------+--------------+-----------
 kuien     | Cannot login |

postgres=# select changeTblUnderSchemaOwner('kuien', 'kuien');
 changetblunderschemaowner
---------------------------

(1 row)

postgres=# \dn kuien
List of schemas
 Name  | Owner
-------+-------
 kuien | kuien
(1 row)

postgres=# \dt kuien.
              List of relations
 Schema | Name | Type  | Owner |   Storage
--------+------+-------+-------+-------------
 kuien  | tb1  | table | kuien | append only
 kuien  | tb2  | table | kuien | append only
(2 rows)
}}

> Support more statements with ALTER OWNER
> ----------------------------------------
>
>                 Key: HAWQ-1556
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1556
>             Project: Apache HAWQ
>          Issue Type: New Feature
>          Components: DDL
>            Reporter: Kuien Liu
>            Assignee: Radar Lei
>
> Except _AlterAggregateOwner_ and _AlterFunctionOwner_, _ExecAlterOwnerStmt_ has commented out all the other statements (comparing with GPDB branch). 
> ```
> # create type complex as (x integer, y integer);
> # create role kuien;
> # alter type complex owner to kuien;
> ERROR:  Cannot support alter type owner statement yet
> ```
> It is not too user friendly, AND I see no reason why not support them. What do you think? Any plan on this?



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)