[Postgres-xc-developers] Fix for test case plancache

[Abbas B. <abb...@en...>]

Hi,
Attached please find a fix for test case plancache.
The test was failing because of the following issue

  create schema s1 create table abc (f1 int) distribute by replication;
  create schema s2 create table abc (f1 int) distribute by replication;
  insert into s1.abc values(123);
  insert into s2.abc values(456);
  set search_path = s1;
  prepare p1 as select f1 from abc;
  set search_path = s2;
  execute p1;

The last execute must send select f1 from s1.abc to the datanode,
despite the fact that the current schema has been set to s2.

The solution was to schema qualify remote queries, and for that the
function generate_relation_name is modified to make sure that relations are
schema qualified independent of current search path.

Expected outputs of many test cases are changed which makes the size and
footprint of this patch large.

-- 
*Abbas*
 Architect

Ph: 92.334.5100153
 Skype ID: gabbasb
www.enterprisedb.co
<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
*
Follow us on Twitter*
@EnterpriseDB

Visit EnterpriseDB for tutorials, webinars,
whitepapers<http://www.enterprisedb.com/resources-community>and
more<http://www.enterprisedb.com/resources-community>