Re: PostgreSQL 10 Partition Tables: Support through PG Driver

 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 <[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