Re: PostgreSQL 10 Partition Tables: Support through PG Driver

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]> <mailto:[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]> <mailto:[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]> <mailto:[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