<html><head></head><body style="zoom: 0%;"><div dir="auto">I get the same error message as if PostGIS isn't installed. Function not found error.<br><br></div>
<div dir="auto">I'm invoking in lambda via python code like this:<br><br></div>
<div dir="auto">import boto3<br></div>
<div dir="auto">import psycopg3<br><br></div>
<div dir="auto">def lambda_handler(event,lambda_context)<br><br></div>
<div dir="auto"># login and connection stuff<br><br></div>
<div dir="auto">cur.execute("select * from schema.udf_name (parm1,parm2)")<br><br></div>
<div dir="auto">The UDF invokes several PostGIS functions such as st_dwithin.<br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Get <!-- tmjah_g_1299e --><a href="http://www.bluemail.me/r?b=15824"><!-- tmjah_g_1299s -->BlueMail for Android<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> <!-- tmjah_g_1299e --></div>
<div class="gmail_quote" >On Mar 17, 2020, at 9:04 AM, Giuseppe Broccolo <<a href="mailto:g.broccolo.7@gmail.com" target="_blank">g.broccolo.7@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr">
<div>
Hi Alexander,
</div>
<div>
<br>
</div>
<div>
can you add further details (snippet of code, etc.) about this?
<br>
<br>Never tried doing this, but AFAIK AWS lambda runs on preconfigured RDS environments,
</div>
<div>
maybe it's just enough to include the CREATE EXTENSION.
</div>
<div>
<br>
</div>
<div>
Giuseppe.
<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">
Il giorno mar 17 mar 2020 alle ore 12:55 Alexander Gataric <
<a href="mailto:gataric@usa.net">gataric@usa.net</a>> ha scritto:
<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
I'm trying to create a service to invoke Postgres UDFs that utilize PostGIS
<br> functions via an AWS lambda function. The error I get is as if the PostGIS
<br> extension is not installed. Has anyone encountered this before?
<br>
<br> Thanks
<br> Alex
<br>
<br> _______________________________________________
<br> postgis-users mailing list
<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</blockquote>
</div>
<pre class="blue"> <hr><br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre></blockquote></div></body></html>