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

2008-12-18 Thread 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

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

2008-12-18 Thread Rushabh Lathia
On Thu, Dec 18, 2008 at 5:14 PM, Anupama Aherrao anupama.aher...@enterprisedb.com wrote: 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));

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

2008-12-18 Thread Tom Lane
Anupama Aherrao anupama.aher...@enterprisedb.com writes: Following INSERT..SELECT with GENERATE_SERIES for bulk insertion returns error on 8.4 cvs head. It looks like an issue. Yeah, looks like I broke this here: http://archives.postgresql.org/pgsql-committers/2008-10/msg00295.php Fixed,