INSERT..SELECT with GENERATE_SERIES returns error. - Mailing list pgsql-hackers

From Anupama Aherrao
Subject INSERT..SELECT with GENERATE_SERIES returns error.
Date
Msg-id 4bf2bd870812180344v74d28412n74b39304a519db7c@mail.gmail.com
Whole thread Raw
Responses Re: INSERT..SELECT with GENERATE_SERIES returns error.  ("Rushabh Lathia" <rushabh.lathia@gmail.com>)
Re: INSERT..SELECT with GENERATE_SERIES returns error.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi All,<br /><br />Following INSERT..SELECT with  GENERATE_SERIES for bulk insertion returns error on 8.4 cvs head.  It
lookslike an issue.<br /><br />Tested on : <u>8.4 CVS Head</u><br /><br />CREATE TABLE t1 ( x int, y char(4));<br />
INSERTINTO  t1  VALUES ( 1, 'edb');<br />INSERT INTO t1 SELECT 10  + GENERATE_SERIES(50,60), y FROM t1 WHERE
y='edb';<br/> ERROR:  unrecognized table-function returnMode: 2822132<br /><br /><br />It should insert 11 tuples
withoutany error or warning....  Inputs ?<br /><br />Thanks,<br /><br />Anupama<br /> 

pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Partitioning wiki page
Next
From: Peter Eisentraut
Date:
Subject: Re: Preventing index scans for non-recoverable index AMs