Re: [Postgres-xc-developers] Detecting XC

[David E. W. <da...@ju...>]

On Feb 5, 2014, at 5:33 PM, Tatsuo Ishii <is...@po...> wrote:

> What about this?
> 
> SELECT count(*) from
> 	   (SELECT has_function_privilege('%s', 'pgxc_version(text)', 'execute')
> 	   WHERE EXISTS(SELECT * FROM pg_catalog.pg_proc AS p WHERE p.proname = 'pgxc_version')) AS s"

I don’t much care about permission, so I would just do

    SELECT TRUE
      FROM pg_catalog.pg_proc p
      JOIN pg_catalog.pg_namespace n ON p.pronamespace = n.oid
     WHERE nspname = 'pg_catalog'
       AND proname = 'pgxc_version';

Best,

David