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:

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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.