[ 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)