Re: PostgreSQL 10 Partition Tables: Support through PG Driver

Hi Mahesh,

On 2018/05/01 8:26, Mahesh Kansara wrote:
> Hello Hiroshi,
>
> I hope you are doing well. Would you be able to give me test drivers
> for linux OS ?
>

Unfortunately I am not even a Linux user.
Do you expect a .so binay or e.g. a .deb package?

regards,
Hiroshi Inoue

> Thanks,
> Mahesh Kansara
>
> On Friday, 27 April, 2018, 10:02:35 AM GMT-7, Mahesh Kansara
> <mahesh_kansara(at)yahoo(dot)com> wrote:
>
>
> Hello Hiroshi,
>
> Thanks for reply, I am using Linux ,x86_64 x86_64 x86_64 GNU/Linux. It
> would be great help if you can give me test drivers.
>
> Thanks,
> Mahesh Kansara
>
> On Thursday, 26 April, 2018, 8:43:01 PM GMT-7, Inoue, Hiroshi
> <h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
>
>
> Hi Mahesh,
>
> On 2018/04/27 6:51, Mahesh Kansara wrote:
>> Hello Hiroshi,
>>
>> Thanks for reply, Is there any web link where I can follow up or
>> check and use new driver when available ?
>
> What kind of OS are you using?
> If you are using Windows, I can provide test drivers.
>
> regards,
> Hiroshi Inoue
>
>
>>
>> Thanks,
>> Mahesh K
>>
>> On Thursday, 26 April, 2018, 2:47:40 PM GMT-7, Inoue, Hiroshi
>> <h-inoue(at)dream(dot)email(dot)ne(dot)jp> <mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
>>
>>
>> Hi Mahesh,
>>
>> On 2018/04/26 12:16, Mahesh Kansara wrote:
>>> Hello Team,
>>>
>>> My name is Mahesh and I am working with one application where we are
>>> connecting with PostgreSQL 10 database using PostgreSQL driver.
>>>
>>> Application is basically trying to get list of tables from target
>>> but not returning Partition tables information.  The query which
>>> PostgreSQL driver is generating is below.
>>>
>>> select relname, nspname, relkind from pg_catalog.pg_class c,
>>> pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname
>>> like 'myschema' and relname like 'mytable' and nspname not in
>>> ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and
>>> n.oid = relnamespace order by nspname, relname
>>>
>>> If I run this query directly on target it doesn't list partition
>>> table. If i change this query to something like below it works.
>>>
>>> select relname, nspname, relkind from pg_catalog.pg_class c,
>>> pg_catalog.pg_namespace n where relkind in ('r', 'v', 'p') and
>>> nspname like 'myschema' and relname like 'mytable' and nspname not
>>> in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and
>>> n.oid = relnamespace order by nspname, relname
>>
>> I would take care of this issue.
>>
>> Thanks.
>> Hiroshi Inoue
>>
>>
>>>
>>> I was looking at latest PostgreSQL driver psqlodbc-10.02.0000 I am
>>> not seeing any code file which returns partition table.
>>>
>>> Can you please share some more information on how to get partition
>>> tables using PostgreSQL driver.
>>>
>>> Please let me know if you need more information.
>>>
>>> Thanks,
>>> Mahesh K