[postgis-users] PostGIS functions not working on AWS via Lambda function

[Giuseppe Broccolo]

Ok, check in which schema PostGIS operators/functions have been defined,
then
use fully qualified names of the functions in your UDF.

Giuseppe.

Il giorno mar 17 mar 2020 alle ore 18:16 Alexander Gataric <gataric at usa.net>
ha scritto:

> It says the extension already exists.
>
> Get BlueMail for Android <http://www.bluemail.me/r?b=15824>
> On Mar 17, 2020, at 12:07 PM, Giuseppe Broccolo <g.broccolo.7 at gmail.com>
> wrote:
>>
>> Ok, as I told befire lambda functions should rely on RDS instances. Once
>> you open a connection
>> to the DB through psycopg, enable the Postgis extension with
>>
>> cur.execute("CREATE EXTENSION postgis")
>>
>> then try to run your UDF.
>>
>> Giuseppe.
>>
>> Il giorno mar 17 mar 2020 alle ore 14:38 Alexander Gataric <
>> gataric at usa.net> ha scritto:
>>
>>> I get the same error message as if PostGIS isn't installed. Function not
>>> found error.
>>>
>>> I'm invoking in lambda via python code like this:
>>>
>>> import boto3
>>> import psycopg3
>>>
>>> def lambda_handler(event,lambda_context)
>>>
>>> # login and connection stuff
>>>
>>> cur.execute("select * from schema.udf_name (parm1,parm2)")
>>>
>>> The UDF invokes several PostGIS functions such as st_dwithin.
>>>
>>> Get BlueMail for Android <http://www.bluemail.me/r?b=15824>
>>> On Mar 17, 2020, at 9:04 AM, Giuseppe Broccolo < g.broccolo.7 at gmail.com>
>>> wrote:
>>>>
>>>> Hi Alexander,
>>>>
>>>> can you add further details (snippet of code, etc.) about this?
>>>>
>>>> Never tried doing this, but AFAIK AWS lambda runs on preconfigured RDS
>>>> environments,
>>>> maybe it's just enough to include the CREATE EXTENSION.
>>>>
>>>> Giuseppe.
>>>>
>>>> Il giorno mar 17 mar 2020 alle ore 12:55 Alexander Gataric <
>>>> gataric at usa.net> ha scritto:
>>>>
>>>>> I'm trying to create a service to invoke Postgres UDFs that utilize
>>>>> PostGIS
>>>>> functions via an AWS lambda function. The error I get is as if the
>>>>> PostGIS
>>>>> extension is not installed. Has anyone encountered this before?
>>>>>
>>>>> Thanks
>>>>> Alex
>>>>>
>>>>> _______________________________________________
>>>>> postgis-users mailing list
>>>>> postgis-users at lists.osgeo.org
>>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>>
>>>>
>>>>        ------------------------------
>>>>
>>>> postgis-users mailing list
>>>> postgis-users at lists.osgeo.org
>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>>
>>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>>  ------------------------------
>>
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200317/a1a5f386/attachment.html>