[sqlalchemy] Re: Problem with inserting row containing a value with type PATH of postgres with geoalchemy2
On Tuesday, March 17, 2020 at 12:06:36 PM UTC-4, Christos Ch wrote: > > I am running a service from a docker container > The error is from psycopg2 and stating the function is not available on the PostgreSQL server. This is most likely because PostGIS is not installed on the server (which could be in the docker container, or elsewhere) or needs to be enabled for that database. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/73ccf694-b521-482a-87c6-a112b5e2d311%40googlegroups.com.
[sqlalchemy] Re: Problem with inserting row containing a value with type PATH of postgres with geoalchemy2
I am running a service from a docker container On Tuesday, March 17, 2020 at 6:04:04 PM UTC+2, Jonathan Vanasco wrote: > > `st_geomfromewkt` is a function in the PostGIS extension to PostgreSQL. > > Are you certain postgis is installed in the server and enabled for the > database? > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/6ad49872-fede-4df9-8456-3ecb65fe5a62%40googlegroups.com.
[sqlalchemy] Re: Problem with inserting row containing a value with type PATH of postgres with geoalchemy2
`st_geomfromewkt` is a function in the PostGIS extension to PostgreSQL. Are you certain postgis is installed in the server and enabled for the database? -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/3cb2d821-e03a-4a96-a2c9-565eb539edf5%40googlegroups.com.
[sqlalchemy] Problem with inserting row containing a value with type PATH of postgres with geoalchemy2
I have a postgres table below with a field `coordinates` of type path: CREATE TABLE geometry ( id serial not null primary key, coordinates path not null ) Trying to add a Geometry into the table: session.add(Geometry(id = 1, coordinates = "path('(15.234428926980286, 47.95865145177352)')")) I am getting this error: sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) function st_geomfromewkt(unknown) does not exist -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/18cf8b5e-d3ec-47b8-95b0-53fe276f06c4%40googlegroups.com.