Renaming flex table should rename keys table as well

Sergey_Cherepan_1

Hi,

There is slightly awkward behaviour of flex table keys table.
Keys table is being created together with flex table, with name

<

table>_keys
When flex table is being moved to other schema, keys table is being moved as well. This is correct.
When flex table is being renamed, keys table is not being renamed.

That leads to rather awkward behaviour when you will rename flex table and move to other schema.

Please ask development to rename keys table together with renaming flex table.

Thank you
Sergey

SruthiA

Yes. it is currently not renaming the keys when running alter. I have raised a new feature request for the same.

testdb=> CREATE FLEX TABLE flex0 (a INT, b VARCHAR);
CREATE TABLE
testdb=> INSERT INTO flex0 VALUES (1, 'x');
-[ RECORD 1 ]
OUTPUT | 1

testdb=> commit;
COMMIT

testdb=> ALTER TABLE flex0 rename to flex_newname;
ALTER TABLE

testdb=> SELECT COMPUTE_FLEXTABLE_KEYS_AND_BUILD_VIEW('flex_newname');

COMPUTE_FLEXTABLE_KEYS_AND_BUILD_VIEW

Please see public.flex0_keys for updated keys
The view public.flex0_view is ready for querying
(1 row)

testdb=>

testdb=> \dt
List of tables
Schema | Name | Kind | Owner | Comment
--------+----------------+-------+---------+---------
public | flex0_keys | table | dbadmin |
public | flex_newname | table | dbadmin |
(2 rows)