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

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

It is now in the bug tracker, ID is 3614635.   I'm afraid it's hard to include this improvement in 1.1.0 but will be fixed in the following releases.   I understand this has high priority.

Regards;
---
Koichi Suzuki



On 2013/07/04, at 22:20, Michael Paquier <mic...@gm...> wrote:

> On Thu, Jul 4, 2013 at 7:07 PM, Pavan Deolasee <pav...@gm...> wrote:
>> 
>> On Thu, Jul 4, 2013 at 3:21 PM, Michael Paquier <mic...@gm...>
>>> generate_series has never been fixed for hash tables as far as I recall.
>> Hmm.. that could well be the case. I am immensely surprised and disappointed
>> if that's true though. IMHO any PostgreSQL user will most likely fire that
>> statement soon after creating a table to populate test data. It does not
>> sound nice if the very first statement errors out.
> +1.
> 
>> What stops us from supporting that, except of course lack of development time?
> That and the fact that such exceptions have never been considered a
> high priority, I suppose. generate_series is the particular case of an
> immutable function that cannot be FQS'ed for a non-replicated table. I
> might be wrong, but I think it worked correctly for roundrobin.
> 
>> Is it a hard problem to crack ?
> No I don't think so, but I've never taken the time to look at it.
> 
>> I assume its the former because we just need to put it
>> through the slow path instead of FQS, no ?
> Yes, this is the case, it takes, or should take the slow path, and
> this even if the function is immutable. I recall that the output of
> EXPLAIN VERBOSE works correctly.
> --
> Michael
> 
> ------------------------------------------------------------------------------
> 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
>