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

On Tue, 17 Mar, 2020, 6:25 pm Alexander Gataric, wrote: > 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 >

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

Thanks, that did it! The extension was public and I modified the set path statement to include it. ⁣Get BlueMail for Android ​ On Mar 17, 2020, 2:55 PM, at 2:55 PM, Giuseppe Broccolo wrote: >Ok, check in which schema PostGIS operators/functions have been >defined, >then >use fully qualified na

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

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 ha scritto: > It says the extension already exists. > > Get BlueMail for Android

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

It says the extension already exists. ⁣Get BlueMail for Android ​ On Mar 17, 2020, 12:07 PM, at 12:07 PM, Giuseppe Broccolo 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 > >c

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

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 ha

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

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)")

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

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 ha scr

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

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