#17 No user table in object browser

Squirrel SQL
closed
Unknown (89)
5
2015-01-08
2002-02-07
No

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?

Regards,
Jürgen Fricke

Discussion

  • Colin Bell

    Colin Bell - 2002-02-08

    Logged In: YES
    user_id=233132

    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
    database.

    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
    with "TABLE", "SYSTEM TABLE", "VIEW", "INDEX", "SYSTEM
    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.

    Col

     
  • Colin Bell

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

    Jürgen Fricke - 2002-02-08

    Logged In: YES
    user_id=145840

    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
    user_id=233132

    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
    user_id=233132

    Fixed in the just released 1.1beta2.

    Col

     

Log in to post a comment.