Re: PostgreSQL 10 Partition Tables: Support through PG Driver

Hello Sir,

Thanks you, I will test this and let you know it that works for me.

Thanks
Mahesh Kansara

Sent from my iPhone

> On May 1, 2018, at 8:04 PM, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
>
> Hi Mahesh,
>
>> On 2018/05/02 6:39, Mahesh Kansara wrote:
>> Hello Hiroshi,
>>
>> Thanks for reply.
>>
>> It would be good if I can have .so binary.
>
> Could you please try https://winpg.jp/~inoue/psqlodbc/linux/psqlodbcw.so ?
>
> regards,
> Hiroshi Inoue
>
>>
>> Thanks,
>> Mahesh Kansara
>> On Monday, 30 April, 2018, 9:41:16 PM GMT-7, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
>>
>>
>>
>> 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> 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