Options

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

  • Options
    Ariel_CaryAriel_Cary Vertica Employee Employee

    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