Re: Bug with DatabaseMetaData and temporary tables/schemas - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Bug with DatabaseMetaData and temporary tables/schemas
Date
Msg-id alpine.BSO.2.00.1011061940240.9117@leary.csoft.net
Whole thread Raw
In response to Bug with DatabaseMetaData and temporary tables/schemas  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Bug with DatabaseMetaData and temporary tables/schemas
List pgsql-jdbc

On Fri, 5 Nov 2010, Thomas Kellerer wrote:

> DatabaseMetaData does not correctly report the implicitely created temporary
> schema when creating a temporary table.

getSchemas is trying to help by not showing you tables that you cannot
access in other backends' temp schemas.  It's not quite smart enough
though.  It's not filtering the toast schemas and it isn't allowing you to
see your own temp schema.

It looks like psql will show you your own temp schema and all of the
temp toast schemas.  So that could potentially be improved as well.

I'll take a look at making getSchemas a little more consistent.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Thomas Kellerer
Date:
Subject: Bug with DatabaseMetaData and temporary tables/schemas
Next
From: Tom Lane
Date:
Subject: Re: Bug with DatabaseMetaData and temporary tables/schemas