Hi. By the way, I tried doing this by using query1 UNION ALL query2 but when I use ORDER BY column1 DESC at the end, I get an error that says something about pool_c$54 not existing. I tried it directly on the backend (schema1 and schema2 are luckily both on the same node), it works properly. Am I missing anything? I'm worried because what if I want to query1 is from node1 and query2 is from node2, I cannot directly query the backend node anymore since they reside on different nodes already. Please help me. Thanks
Regards, Viril > Sir, > > I really need this thing to work. In parallel mode, I cannot do INSERT > INTO ... SELECT as per the manual and I personally tried this, says > inconsistent backends. What I need to do is to merge selected data from > schema1.table1 with schema2.table1 and query the merged data. What we do > in MySQL is to create a Temp table, insert selected data from > database1.table1 and database2.table1 to the Temp table then query that > table. How can I do the same thing without using INSERT INTO ... SELECT > please? I can't move on without solving this problem first. Thank you so > much. > > Regards, > Viril Calimlim > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general > > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
