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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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