Empty columns tab in the Table-Details when connected to Postgres

Toad Data Point & Toad Intelligence Central
1

When connected to Postgres, using the PostgreSQL ANSI(x64) Driver for PostgreSQL 12, PostgresSQL ODBC Driver 9.05 and Toad Data Point (TDP) 4.3.0.718 (64 bit), and right-clicking on a table in the Object Explorer:

    • Selecting " View Details ", and looking at the " Columns " tab, it's empty, the info about the columns is missing, no error messages.
    • Selecting " Generate SQL | Select Statement | To Editor ", it shows:

-- Toad Data Point can't find columns. The object may be invalid or a type that is not supported.

Looks like the same issue as 232520 on support.quest.com, but I don't have permission to view the solution.

The above scenario works with Oracle and MySql.

Thanks!

2

Copied the KB article from our Support site below... although it involves ODBC for another platform (Cloudera Impala) hoping that the work-around might work in your case with Postgres...

Title

Empty columns tab in the Table-Details when connected to Cloudera Impala

Description

When connected to Cloudera Impala, using the Cloudera ODBC Driver for Impala version 2.5.36.1009 64-bit and Toad Data Point (TDP) 4.2.1.303 (64 bit), and right-clicking on a table in the Object Explorer:

    • Selecting " View Details ", and looking at the " Columns " tab, it's empty, the info about the columns is missing, no error messages.
    • Selecting " Generate SQL | Select Statement | To Editor ", it shows:

-- Toad Data Point can't find columns. The object may be invalid or a type that is not supported.

Resolution

WORKAROUND 1:

Right-click on the table in the Object Explorer, and click on " Refresh All ", and try again.

WORKAROUND 2:

Try installing the Cloudera ODBC Driver for Impala version 2.5.39.1020 64-bit, and once the connection is using it, again, right-click on the table in the Object Explorer, and click on " Refresh All ", and try again.