[ jEdit-devel ] [ jedit-Plugin Bugs-1276454 ] SQL plugin 1.02 bug with Postgres 7.2

[SourceForge.net <no...@so...>]

Plugin Bugs item #1276454, was opened at 2005-08-30 11:31
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=565475&aid=1276454&group_id=588

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Matthieu Casanova (kpouer)
Assigned to: Nobody/Anonymous (nobody)
Summary: SQL plugin 1.02 bug with Postgres 7.2

Initial Comment:
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

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=565475&aid=1276454&group_id=588