[Pgpool-general] Pgpool-II - Parallel Query - Multiple Schema

[calimlimvl at nationalbookstore.com.ph]

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
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
>