[Postgres-xl-general] Unrecognized node type: 118

Aaron Jackson 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

Aaron
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20140923/c8cd3889/attachment.htm>


More information about the postgres-xl-general mailing list