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