Re: System Query hit to Database - Mailing list pgsql-jdbc

From dhaval jaiswal
Subject Re: System Query hit to Database
Date
Msg-id PN1PR01MB00468593009E479AD8FBDEC7DFAA0@PN1PR01MB0046.INDPRD01.PROD.OUTLOOK.COM
Whole thread Raw
In response to System Query hit to Database  (dhaval jaiswal <dhavallj@hotmail.com>)
Responses Re: System Query hit to Database
Re: System Query hit to Database
List pgsql-jdbc

Can anyone help me on below query.





From: dhaval jaiswal <dhavallj@hotmail.com>
Sent: Thursday, February 11, 2016 10:32 AM
To: pgsql-jdbc@postgresql.org
Subject: System Query hit to Database
 

Kindly redirect me to the correct forum, If below question is not relevant to you.  



I am getting lot of following queries on my Database.  I need  your help to stop hitting this kind of queries to database.

While going through search found the following article saying it's caused by jdbc driver.

http://stackoverflow.com/questions/5453992/a-very-strange-sql-of-postgresql

 

SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME,  CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema'  WHEN true THEN CASE  WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TABLE'   WHEN 'v' THEN 'SYSTEM VIEW'   WHEN 'i' THEN 'SYSTEM INDEX'   ELSE NULL   END  WHEN n.nspname = 'pg_toast' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TOAST TABLE'   WHEN 'i' THEN 'SYSTEM TOAST INDEX'   ELSE NULL   END  ELSE CASE c.relkind   WHEN 'r' THEN 'TEMPORARY TABLE'   WHEN 'i' THEN 'TEMPORARY INDEX'   WHEN 'S' THEN 'TEMPORARY SEQUENCE'   WHEN 'v' THEN 'TEMPORARY VIEW'   ELSE NULL   END  END  WHEN false THEN CASE c.relkind  WHEN 'r' THEN 'TABLE'  WHEN 'i' THEN 'INDEX'  WHEN 'S' THEN 'SEQUENCE'  WHEN 'v' THEN 'VIEW'  WHEN 'c' THEN 'TYPE'  ELSE NULL  END  ELSE NULL  END  AS TABLE_TYPE, d.description AS REMARKS  FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c  LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0)  LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog')  WHERE c.relnamespace = n.oid  AND c.relname LIKE 'PROBABLYNOT'  AND (false  OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) )  ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME



Environment details:

Version: PostgreSQL 9.4.0

Driver version: postgresql-9.4-1201.jdbc41.jar

JVM: 1.7



pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: System Query hit to Database
Next
From: Vladimir Sitnikov
Date:
Subject: Re: System Query hit to Database