Re: Bug with DatabaseMetaData and temporary tables/schemas

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Bug with DatabaseMetaData and temporary tables/schemas
Дата
Msg-id ib5ork$45l$1@dough.gmane.org
обсуждение исходный текст
Ответ на Re: Bug with DatabaseMetaData and temporary tables/schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Bug with DatabaseMetaData and temporary tables/schemas  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
Tom Lane wrote on 07.11.2010 02:02:
> Kris Jurka<books@ejurka.com>  writes:
>> 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.
>
> Yeah, there was some discussion of that just recently:
> http://archives.postgresql.org/message-id/16710.1284837096@sss.pgh.pa.us
>
> I haven't got round to making that change yet, but maybe now is a
> good time.  The consensus seemed to be that \dn (without S) should
> not show any pg_XXX schemas, nor information_schema.  Not sure that
> that's appropriate for getSchemas though --- an API intended for
> programs should maybe just hide the temp and toast schemas.
>

Well it should at least show "my" temp schemas.

Or getColumns() and getTables() should be smart enough to return information about temp tables without having to
specifythe temp schema. 

Regards
Thomas

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug with DatabaseMetaData and temporary tables/schemas
Следующее
От: Michael Fork
Дата:
Сообщение: PSQLException: The column name was not found in this ResultSet.