Re: BUG #11761: range_in dosn't work via direct functional call

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: <olegjobs(at)mail(dot)ru>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #11761: range_in dosn't work via direct functional call
Date: 2014-10-24 13:08:30
Message-ID: 544A4F4E.9080407@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 10/22/2014 08:27 PM, olegjobs(at)mail(dot)ru wrote:
> This function test_ext_get_range(cstring) returns int4range:
>
> Datum test_ext_get_range(PG_FUNCTION_ARGS)
> {
> char *ts = PG_GETARG_CSTRING(0);
>
> return DirectFunctionCall3(range_in, CStringGetDatum(ts),
> ObjectIdGetDatum(3904), Int32GetDatum(0);
> }
> In psql:
> select test_ext_get_range('[1,1]');
> error:
> connection to the server was lost.
>
> it seems to me that some memory problems because of "The range I/O functions
> need a bit more cached info than other range
> * functions, so they store a RangeIOData struct in fn_extra, not just a
> * pointer to a type cache entry. "

Yeah, DirectFunctionCall cannot be used with range_in. Use FunctionCall3
instead. See this comment in fmgr.c, above DirectFunctionCall1Coll:

> /*
> * These are for invocation of a specifically named function with a
> * directly-computed parameter list. Note that neither arguments nor result
> * are allowed to be NULL. Also, the function cannot be one that needs to
> * look at FmgrInfo, since there won't be any.
> */

range_in needs to look at FmgrInfo.

- Heikki

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2014-10-24 13:36:31 Re: [BUGS] BUG #11767: ODBC driver bug when fetching constant string columns
Previous Message Heikki Linnakangas 2014-10-24 10:52:48 Re: BUG #11749: range_in, range_out dosn't work