BUG #8657: Postgres 9.3 JDBC driver is unable to find the Foreign tables

From: plalg(at)hotmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8657: Postgres 9.3 JDBC driver is unable to find the Foreign tables
Date: 2013-12-04 22:52:27
Message-ID: E1VoLIx-0002Fs-SQ@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8657
Logged by: Prakash Lal
Email address: plalg(at)hotmail(dot)com
PostgreSQL version: 9.3.0
Operating system: Windows 7
Description:

Postgres 9.3 JDBC driver is unable to find the Foreign tables.

Found the cause, the hashmap values for "FOREIGN TABLE" in
AbstractJdbc2DatabaseMetaData class is getting overwritten by "MATERIALIZED
VIEW" values:

Before
ht = new HashMap();
tableTypeClauses.put("FOREIGN TABLE", ht);
ht.put("SCHEMAS", "c.relkind = 'f'");
ht.put("NOSCHEMAS", "c.relkind = 'f'");
tableTypeClauses.put("MATERIALIZED VIEW", ht);
ht.put("SCHEMAS", "c.relkind = 'm'");
ht.put("NOSCHEMAS", "c.relkind = 'm'");

After (fix):
ht = new HashMap();
tableTypeClauses.put("FOREIGN TABLE", ht);
ht.put("SCHEMAS", "c.relkind = 'f'");
ht.put("NOSCHEMAS", "c.relkind = 'f'");
ht = new HashMap(); // this is the line missing
tableTypeClauses.put("MATERIALIZED VIEW", ht);
ht.put("SCHEMAS", "c.relkind = 'm'");
ht.put("NOSCHEMAS", "c.relkind = 'm'");

thanks
Prakash

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2013-12-05 01:33:07 Re: BUG #8656: Duplicate data violating unique constraints
Previous Message maciek 2013-12-04 20:04:15 BUG #8656: Duplicate data violating unique constraints