Re: Release 1204 released

That's fine. I'll revert it. But I think the previous issue was that it was
also returning indexes as well. I'll just narrow down to tables, views, and
mat views

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 15 October 2015 at 17:39, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> All I can say is, that due to the nature of SQL Workbench (being DBMS
> independent) I do use (or at least test)
> many other DBMS and every[1] other JDBC driver does return view columns -
> including materialized views in Oracle and DB2.
>
> So apparently all the other vendors think it makes sense to return view
> (and materialized view) columns.
>
> Thomas
>
> [1] I have tested at least briefly more than 15 different ones.
>
>
> Dave Cramer schrieb am 15.10.2015 um 22:47:
>
>> So I am looking at the API reference and no where does it say getColumns
>> should return information about views.
>>
>> That being said the fact that getTables returns the type of the table
>> there may be some inference that it should ?
>>
>> Lance, do you have some insight here ?
>>
>> Dave Cramer
>>
>> On 15 October 2015 at 05:10, Thomas Kellerer <spam_eater(at)gmx(dot)net
>> <mailto:spam_eater(at)gmx(dot)net>> wrote:
>>
>> Dave Cramer schrieb am 09.10.2015 um 21:32:
>>
>>> * fix: filter DatabaseMetaData.getColumns by tables PR #386
>>> (0c95126)
>>>
>>
>> Why was this done?
>>
>> From my perspective this is a serious bug, because now getColumns()
>> doesn't return column information for views, materialized views or
>> foreign tables any more.
>>
>> Which in turn means that the SQL client I am maintaining (SQL
>> Workbench/J) is no longer able to display column information for
>> anything else than tables.
>>
>> I would assume that this is true for any other JDBC based SQL client.
>> It will also break tools like Liquibase and probably Hibernate as
>> well as they also rely on getColumns() to return information about
>> views (I am sure about Liquibase, not 100% sure about Hibernate
>> though)
>>
>>
>> Regards Thomas
>>
>
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>