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

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

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