Обсуждение: PostgreSQL 10 Partition Tables: Support through PG Driver
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 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
Hi Mahesh,
I would take care of this issue.
Thanks.
Hiroshi Inoue
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, relnameIf 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
Hello Hiroshi,
Thanks for reply, Is there any web link where I can follow up or check and use new driver when available ?
Thanks,
Mahesh K
On Thursday, 26 April, 2018, 2:47:40 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.jp> wrote:
Hi Mahesh,
I would take care of this issue.
Thanks.
Hiroshi Inoue
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, relnameIf 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
Hi Mahesh,
What kind of OS are you using?
If you are using Windows, I can provide test drivers.
regards,
Hiroshi Inoue
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 KOn Thursday, 26 April, 2018, 2:47:40 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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, relnameIf 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 InoueI 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
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@dream.email.ne.jp> wrote:
Hi Mahesh,
What kind of OS are you using?
If you are using Windows, I can provide test drivers.
regards,
Hiroshi Inoue
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 KOn Thursday, 26 April, 2018, 2:47:40 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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, relnameIf 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 InoueI 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
Hello Hiroshi,
I hope you are doing well. Would you be able to give me test drivers for linux OS ?
Thanks,
Mahesh Kansara
On Friday, 27 April, 2018, 10:02:35 AM GMT-7, Mahesh Kansara <mahesh_kansara@yahoo.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@dream.email.ne.jp> wrote:
Hi Mahesh,
What kind of OS are you using?
If you are using Windows, I can provide test drivers.
regards,
Hiroshi Inoue
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 KOn Thursday, 26 April, 2018, 2:47:40 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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, relnameIf 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 InoueI 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
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 KansaraOn Friday, 27 April, 2018, 10:02:35 AM GMT-7, Mahesh Kansara <mahesh_kansara@yahoo.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 KansaraOn Thursday, 26 April, 2018, 8:43:01 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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 InoueThanks,Mahesh KOn Thursday, 26 April, 2018, 2:47:40 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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, relnameIf 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 InoueI 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
Hello Hiroshi,
Thanks for reply.
It would be good if I can have .so binary.
Thanks,
Mahesh Kansara
On Monday, 30 April, 2018, 9:41:16 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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 KansaraOn Friday, 27 April, 2018, 10:02:35 AM GMT-7, Mahesh Kansara <mahesh_kansara@yahoo.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 KansaraOn Thursday, 26 April, 2018, 8:43:01 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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 InoueThanks,Mahesh KOn Thursday, 26 April, 2018, 2:47:40 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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, relnameIf 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 InoueI 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
Hi Mahesh,
Could you please try https://winpg.jp/~inoue/psqlodbc/linux/psqlodbcw.so ?
regards,
Hiroshi Inoue
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 KansaraOn Monday, 30 April, 2018, 9:41:16 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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 InoueThanks,Mahesh KansaraOn Friday, 27 April, 2018, 10:02:35 AM GMT-7, Mahesh Kansara <mahesh_kansara@yahoo.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 KansaraOn Thursday, 26 April, 2018, 8:43:01 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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 InoueThanks,Mahesh KOn Thursday, 26 April, 2018, 2:47:40 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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, relnameIf 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 InoueI 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
Hello Sir,
Thanks you, I will test this and let you know it that works for me.
Thanks
Mahesh Kansara
Sent from my iPhone
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 InoueThanks,Mahesh KansaraOn Monday, 30 April, 2018, 9:41:16 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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 InoueThanks,Mahesh KansaraOn Friday, 27 April, 2018, 10:02:35 AM GMT-7, Mahesh Kansara <mahesh_kansara@yahoo.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 KansaraOn Thursday, 26 April, 2018, 8:43:01 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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 InoueThanks,Mahesh KOn Thursday, 26 April, 2018, 2:47:40 PM GMT-7, Inoue, Hiroshi <h-inoue@dream.email.ne.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, relnameIf 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 InoueI 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