How to fix multiple table declaration after materialize_flextable_columns?
Alexander_Magon
Vertica Customer
After applying materialize_flextable_columns to a flex table \dt returns many same named tables with different comments like "Addedd successfully: some column", so I have so many table dups as materialized columns.
Simple research sows that all_tables contains multiple rows about the same table with just different "remarks".
version 09.03.0000
Utilities like DBeaver showing many copies too and hang with refresh.
Tagged:
0
Answers
Hello. We're aware of that problem. Unfortunately that output is bogus. You do not actually have table duplicates in the database. Please use
select * from tables
to get the list of tables as a workaround for now. We're working to fix that output in a future release.