#17 No user table in object browser

Squirrel SQL
Unknown (89)

I use a Squirrel Client version 1.0final1 as a frontend for my postgreSQL 6.5.2
database. The driver i use is "jdbc6.5-1.2.jar".
After a connection i see 6 times the entry "SYSTEM TABLE" in the object browser,
one "UDT" named entry but no user table data.

With a SQL query i can sucessful select any data.

Any suggestions?

Jürgen Fricke


  • Colin Bell

    Colin Bell - 2002-02-08

    Logged In: YES

    Earlier versions of the JDBC driver that shipped with
    PostgreSQL didn't implement the database metadata
    functionality correctly. This is a problem for SQuirreL as
    the object tree relies heavily on the metadata from the

    Version 7.1.3. of PostgreSQL and JDBC driver work
    correctly. Theres also a fix within SQuirreL so that it
    works with 7.1.2.

    I'll put up a change in 1.1beta2 that will check the table
    types returned from the metadata and if six versions
    of "SYSTEM TABLE" are returned I will replace them
    INDEX" and "SEQUENCE".

    However there is no guarantee that your version of
    PostgreSQL will return a list of tables for these table
    types - we'll just have to see.

    If you expand any of the "SYSTEM TABLE" nodes do you see a
    list of tables or are they empty? If you're seeing a
    correct list of tables here then there is a good chance
    that this fix will work for the other tables types as well.


  • Colin Bell

    Colin Bell - 2002-02-08
    • assigned_to: nobody --> colbell
  • Jürgen Fricke

    Jürgen Fricke - 2002-02-08

    Logged In: YES

    Every time i open one of the 6 "SYSTEM TABLE" nodes i see
    a list of postgreSQL system tables. Under all of them the tables
    are exactly the same.

    In the next few weeks i update my postgreSQL to a new version.

    Jrgen Fricke

  • Colin Bell

    Colin Bell - 2002-02-11

    Logged In: YES

    This fix is now in CVS in the module squirrel-sql. It will
    be available in 1.1beta2.

  • Colin Bell

    Colin Bell - 2002-03-27
    • status: open --> closed
  • Colin Bell

    Colin Bell - 2002-03-27

    Logged In: YES

    Fixed in the just released 1.1beta2.



Log in to post a comment.