Re: [google-cloud-sql-discuss] PostgreSQL, Postgis, ST_GeomFromGeoJSON and JSON-C

Hi Google team,

We are needing this feature to migrate our application on Google Cloud. Our only alternative si to create ourselves a Postgres cluster, but I prefer to use Cloud SQL.

I hope you can prioritize this important feature.

Thanks

Le vendredi 19 mai 2017 19:40:37 UTC+2, Ankush Agarwal a écrit :

We have a feature request for this and this will help us prioritize.

On Fri, May 19, 2017 at 10:29 AM, Samuel ROZE <samue...@gmail.com> wrote:

I've being trying to use Google Cloud SQL PostgreSQL with Postgis. After experiencing the "missing uuid-ossp extension issue", I've been trying to use the "ST_GeomFromGeoJSON" function:

```

INSERT INTO "locations" ("id","datetime","travelIdentifier","point","accuracy","altitude","altitudeAccuracy","heading","speed","segment") VALUES (DEFAULT,'2017-05-19 17:17:33.022 +00:00','93d4bc6e-ea3e-46db-95e4-4f5ee450070a',ST_GeomFromGeoJSON('{"type":"Point","coordinates":[-122.31259857,37.49677685]}'),5,0,-1,297.42,32.73,7) RETURNING *;

ERROR:  You need JSON-C for ST_GeomFromGeoJSON

```

Based on Postgis' documentation, JSON-C is a required dependency and I understood from various Search queries that it is why I would have this issue. Any idea how, if possible, can we get Postgres with JSON-C ?

Thank you very much,

Samuel.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/33ea88b1-e478-4ceb-a4d5-6b6251fa21db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Ankush Agarwal

Software Engineer, Cloud SQL

 

There are 10 types of people in this world - those who understand binary and those who don't

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/32e3156f-c49e-4021-9537-83a3bcad70ed%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.