diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-05-17 11:54:04 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-05-17 11:54:04 +0000 |
| commit | a8a487df9f87d28d39b625adfb50cddeb7aef65f (patch) | |
| tree | cea8145ae97eae77f6c777c9849232b65f1d73ae /src | |
| parent | f107174e8c722b791678a2f46da7164a9e2e1920 (diff) | |
| download | postgresql-a8a487df9f87d28d39b625adfb50cddeb7aef65f.tar.gz postgresql-a8a487df9f87d28d39b625adfb50cddeb7aef65f.zip | |
Fix pg_index statistics query to join proper relation.
Diffstat (limited to 'src')
| -rw-r--r-- | src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java | 2 | ||||
| -rw-r--r-- | src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java b/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java index 02f6b06a276..e3f36cae00d 100644 --- a/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java +++ b/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java @@ -2658,7 +2658,7 @@ public class DatabaseMetaData implements java.sql.DatabaseMetaData "WHERE ((c.relname = '" + tableName.toLowerCase() + "') " + " AND (c.oid = x.indrelid) " + " AND (i.oid = x.indexrelid) " + - " AND (c.relam = a.oid)) " + + " AND (i.relam = a.oid)) " + "ORDER BY x.indisunique DESC, " + " x.indisclustered, a.amname, i.relname"); while (r.next()) { diff --git a/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java b/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java index a17e9e1d84a..749c2ba83cd 100644 --- a/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java +++ b/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java @@ -2656,7 +2656,7 @@ public class DatabaseMetaData implements java.sql.DatabaseMetaData "WHERE ((c.relname = '" + tableName.toLowerCase() + "') " + " AND (c.oid = x.indrelid) " + " AND (i.oid = x.indexrelid) " + - " AND (c.relam = a.oid)) " + + " AND (i.relam = a.oid)) " + "ORDER BY x.indisunique DESC, " + " x.indisclustered, a.amname, i.relname"); while (r.next()) { |