[Postgres-xc-developers] SRF not working ?

[Pavan D. <pav...@gm...>]

Hello All,

I tried to use generate_series() function to load a bunch of test data in a
table. It fails with the following error:

psql (PGXC 1.1devel, based on PG 9.2beta2)
Type "help" for help.

postgres=# CREATE TABLE testtbl(a int, b char(10));
CREATE TABLE
postgres=# \d+ testtbl
                           Table "public.testtbl"
 Column |     Type      | Modifiers | Storage  | Stats target | Description
--------+---------------+-----------+----------+--------------+-------------
 a      | integer       |           | plain    |              |
 b      | character(10) |           | extended |              |
Has OIDs: no
Distribute By: HASH(a)
Location Nodes: ALL DATANODES

postgres=# INSERT INTO testtbl VALUES (generate_series(1,10000), 'foo');
ERROR:  set-valued function called in context that cannot accept a set

I thought we had fixed this issue long back, no ? I also tried to search
the list and it seems it used to work at some point. Am I doing something
wrong ? I'm using the master branch from the repository.

Thanks,
Pavan
-- 
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee