From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Temporary schemas |
Date: | 2010-11-01 22:28:56 |
Message-ID: | ianev0$atr$1@dough.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Merlin Moncure wrote on 01.11.2010 23:13:
> On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellerer<spam_eater(at)gmx(dot)net> wrote:
>> The problem is, that the JDBC driver only returns information about the temp
>> tables, if I specify that schema directly.
>
> Have you filed a bug report to jdbc yet? :-D.
I thought about it initially, but then realized that it works as documented by the JDBC API.
When requesting the table information without specifying a schema, it is returned.
But in my application I use the current schema to request information about non-qualified tables which obviously fails as the current schema is usually public or another user schema but never pg_temp_xxx. So even though a select from a temp table (whithout a schema) works fine from within JDBC, retrieving metadata only works when either specifying no schema, or the correct one - which is a bit confusing but absolutely according to the JDBC specs.
Regards
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Tripathy | 2010-11-01 22:39:03 | Re: Replication |
Previous Message | Rob Sargent | 2010-11-01 22:19:05 | Re: Temporary schemas |