Skip to main content
Question

How to fix multiple table declaration after materialize_flextable_columns?

  • April 3, 2020
  • 1 reply
  • 0 views

Alexander_Magon

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.

1 reply

Ariel_Cary
Forum|alt.badge.img
  • Participating Frequently
  • April 3, 2020

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.