[HACKERS] INSERT..SELECT with GENERATE_SERIES returns error.

[Anupama Aherrao]

Hi All,

Following INSERT..SELECT with  GENERATE_SERIES for bulk insertion returns
error on 8.4 cvs head.  It looks like an issue.

Tested on : *8.4 CVS Head*

CREATE TABLE t1 ( x int, y char(4));
INSERT INTO  t1  VALUES ( 1, 'edb');
INSERT INTO t1 SELECT 10  + GENERATE_SERIES(50,60), y FROM t1 WHERE y='edb';
ERROR:  unrecognized table-function returnMode: 2822132


It should insert 11 tuples without any error or warning....  Inputs ?

Thanks,

Anupama