[Postgres-xl-general] Unrecognized node type: 118
ajackson at revionics.com
Tue Sep 23 10:45:14 PDT 2014
Was creating a sample to demonstrate a problem with another issue I reported and came across this. For completeness, I'm giving you everything I did.
create database sandbox;
# switch to sandbox
create schema client;
reate table client.sales( storeid int not null, productid int not null, revenue numeric not null) with(oids = false) distribute by hash(storeid);
# insert some data into the table
with client_data as (select (100*random())::int as storeid, (10000*random())::int as productid, round((random()*100)::numeric,2) as revenue from generate_series(1,100)) insert into client.sales select * from client_data;
ERROR: unrecognized node type: 118
# just insert directly?
insert into client.sales(storeid, productid, revenue) select (100*random())::int as storeid, (10000*random())::int as productid, round((random()*100)::numeric,2) as revenue from generate_series(1,100);
ERROR: Timeout while waiting for Consumers finishing
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgres-xl-general