Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How to fix multiple table declaration after materialize_flextable_columns?
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
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
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.