[Postgres-xc-developers] In XC, SQL functions cannot contain utility statements

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

XCers,

I just tried to use pgTAP on XC and got this error:

   dwheeler=# create extension pgtap;
   ERROR:  In XC, SQL functions cannot contain utility statements
   CONTEXT:  SQL function "_cleanup"

This is _cleanup():

   CREATE OR REPLACE FUNCTION _cleanup()
   RETURNS boolean AS $$
       DROP TABLE __tresults__;
       DROP SEQUENCE __tresults___numb_seq;
       DROP TABLE __tcache__;
       DROP SEQUENCE __tcache___id_seq;
       SELECT TRUE;
   $$ LANGUAGE sql;

These are temporary objects created by an EXECUTE statement in another function. Are they disallowed?

Google just turned up the XC source:

 https://github.com/postgres-xc/postgres-xc/blob/master/src/backend/catalog/pg_proc.c#L897

Maybe those errors should be re-worded to indicate *what* utility statements are disallowed. Happy to contribute a patch if someone can list them.

Otherwise, I would be interested to figure out how I could work around this issue on XC.

Thanks,

David