Menu

#497 SQL plugin 1.02 bug with Postgres 7.2

open
nobody
None
5
2012-08-07
2005-08-30
No

Hi, there is a bug with and postgres 7.2.4 :
in the postgresVFS when I have the list of the
databases, if I double click on one of them the plugin
will try to get the schemaname, but it doesn't exists
in postgres 7.2.4
This query fails :
SELECT DISTINCT schemaname
FROM pg_tables

After a check the fields of the view pg_tables, the
field schemaname doesn't exists with this version of
postgres.
the existing fields are
tablename
tableowner
hasindexes
hasrules
hastriggers

Discussion

  • Sergey V. Udaltsov

    Logged In: YES
    user_id=681
    Originator: NO

    How does Postgres 7.2.4 distinguishes different schemas/databases/...?

     
  • Sergey V. Udaltsov

    • assigned_to: nobody --> svu
     
  • Alan Ezust

    Alan Ezust - 2012-08-07
    • assigned_to: svu --> nobody
     

Log in to post a comment.