Re: Bug with DatabaseMetaData and temporary tables/schemas

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Bug with DatabaseMetaData and temporary tables/schemas
Дата
Msg-id alpine.BSO.2.00.1011061940240.9117@leary.csoft.net
обсуждение исходный текст
Ответ на Bug with DatabaseMetaData and temporary tables/schemas  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: Bug with DatabaseMetaData and temporary tables/schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Bug with DatabaseMetaData and temporary tables/schemas
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug with DatabaseMetaData and temporary tables/schemas