[pgrouting-dev] can not find the definition of the function
Jinfu Leng
logicnut at gmail.com
Thu Jun 14 04:21:51 PDT 2012
Hello Jay,
Thanks very much.
You need to create a .sql file and write function definition.
I did not know how to create the .sql file. I added the definition of the
function:
CREATE OR REPLACE FUNCTION shortest_path_mild_two_q(sql text, source_id
integer,
target_id integer, directed boolean, has_reverse_cost boolean)
RETURNS SETOF path_result
AS '$libdir/librouting'
LANGUAGE 'C' IMMUTABLE STRICT;
to the file "rounting_core.sql".
Modify cmakelists accordingly.
Which cmakelists.txt file are you referring to? I updated the
cmakelists.txt file in the folder "core/src".
It is not working right now.
Jinfu
On Thu, Jun 14, 2012 at 11:32 AM, Jay Mahadeokar
<jai.mahadeokar at gmail.com>wrote:
> Hi Jinfu,
> It seems that your function is not created in postgres database. You need
> to create a .sql file and write function definition. Modify cmakelists
> accordingly.
> If you have already done that, and didn't work, try adding it by giving
> the command at sql prompt. Check out the documentation in apsp page in
> pgrouting wiki for exact commands.
> On 14 Jun 2012 07:52, "Jinfu Leng" <logicnut at gmail.com> wrote:
>
>> Hey,
>>
>> I am writing the code for the new algorithm. I added the name of the file
>> to the file "CMakeLists.txt", and then the file can be compiled. In
>> pgAdmin3, I can call the function shortest_path(), but when I tried to call
>> my function shortest_path_mild_two_q(), I got the error message "no matched
>> function".
>>
>> My question is, besides "CMakeLists.txt", what else should I do to let
>> the system know there is a function named shortest_path_mild_two_q().
>>
>> Thanks,
>> Jinfu
>>
>> _______________________________________________
>> pgrouting-dev mailing list
>> pgrouting-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>>
>>
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20120614/e066bf00/attachment.html>
More information about the pgrouting-dev
mailing list