Error out / warn on ALTER TABLE SET SCHEMA and ALTER TABLE ALL IN TABLESPACE

[sumedhpathak]

Currently, we only hook into AlterTableStmt and RenameStmt. We should also hook into these commands and error out (or warn).

[onderkalaci]

The steps to produce an error:

CREATE SCHEMA tpch;

CREATE TABLE nation_hash (
    n_nationkey integer not null,
    n_name char(25) not null,
    n_regionkey integer not null,
    n_comment varchar(152));

SELECT master_create_distributed_table('nation_hash', 'n_nationkey', 'hash');
SELECT master_create_worker_shards('nation_hash', 4, 1);

\COPY nation_hash FROM STDIN WITH CSV
1,'name',1,'comment_1'
2,'name',2,'comment_2'
3,'name',3,'comment_3'
4,'name',4,'comment_4'
5,'name',5,'comment_5'

SELECT * FROM nation_hash;
 n_nationkey |          n_name           | n_regionkey |  n_comment  
-------------+---------------------------+-------------+-------------
           1 | 'name'                    |           1 | 'comment_1'
           5 | 'name'                    |           5 | 'comment_5'
           3 | 'name'                    |           3 | 'comment_3'
           4 | 'name'                    |           4 | 'comment_4'
           2 | 'name'                    |           2 | 'comment_2'
(5 rows)

ALTER TABLE nation_hash SET SCHEMA tpch;

SELECT * FROM tpch.nation_hash;
WARNING:  Bad result from localhost:9700
DETAIL:  Remote message: relation "tpch.nation_hash_102008" does not exist

[byucesoy]

For ALTER TABLE SET SCHEMA, I think there is not much work between warning out or actually propagating it to workers. With #662 we support ALTER TABLE SET SCHEMA and warn out for ALTER TABLE ALL IN TABLESPACE.