Re: Release 1204 released

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Release 1204 released
Date: 2015-10-15 22:49:41
Message-ID: CADK3HH+o0P15dLUZDeg4zn+htM9aj6i18+w39JBOBmi5YDhVZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

This was the original issue

https://github.com/pgjdbc/pgjdbc/issues/374

I don't think returning test_table_pkey is correct, hence the change

Dave Cramer

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

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

> Wouldn't it make more sense to _exclude_ those types that should
> absolutely not appear there?
>
> I don't really see the point of excluding anything there in the first place
> to be honest.
>
> This method won't get called "accidently" with some random object name.
> If that is an index (or something else), that's what the user requested.
>
> As indexes and tables share the same namespace there will never be
> any ambiguity which object is meant.
>
> Currently the driver also returns columns for types "create type foo as
> ..."
> I do rely on that as well.
>
> Regards
> Thomas
> Dave Cramer schrieb am 15.10.2015 um 23:53:
>
>> 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 <mailto:davec(at)postgresintl(dot)com>
>> www.postgresintl.com <http://www.postgresintl.com>
>>
>> On 15 October 2015 at 17:39, Thomas Kellerer <spam_eater(at)gmx(dot)net <mailto:
>> 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.
>>
>
>
>
>
> --
> 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
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michał Niklas 2015-10-16 05:30:04 Re: Change of format of returned flat value after prepareThreshold
Previous Message Thomas Kellerer 2015-10-15 22:19:04 Re: Release 1204 released