Re: [Postgres-xc-developers] Detecting XC

[Tatsuo I. <is...@po...>]

> PGXC Hackers,
> 
> What is the simplest way to tell if the server one has connected to is XC? Try to call pgxc_version()? `SHOW gtm_host`? Or is there something else to check, maybe something that doesn't throw an exception?

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"

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp