Re: [Postgres-xc-developers] SRF not working ?

[鈴木 幸市 <ko...@in...>]

We've cleaned up some function I/F and it may influenced the case.

Any more info?
---
Koichi Suzuki



On 2013/07/04, at 17:34, Pavan Deolasee <pav...@gm...> wrote:

> 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
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
> 
> Build for Windows Store.
> 
> http://p.sf.net/sfu/windows-dev2dev_______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers