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

[Michael P. <mic...@gm...>]

On Thu, Jul 4, 2013 at 5:34 PM, 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.
generate_series has has never been fixed for hash tables as far as I recall.
--
Michael