Re: PostgreSQL 10 Partition Tables: Support through PG Driver
"Inoue, Hiroshi" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <[email protected]> |
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