Re: PostgreSQL 10 Partition Tables: Support through PG Driver

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