GePoint create ERROR

[mkzaker]

hi
When I want to create a model that includes the GeoPoint Type , getting the following error
{
"error": {
"name": "error",
"status": 500,
"message": "invalid input syntax for type point: "{"lat":59.6150515,"lng":36.2876827}"",
"length": 122,
"severity": "ERROR",
"code": "22P02",
"file": "geo_ops.c",
"line": "1820",
"routine": "point_in",
"stack": "error: invalid input syntax for type point: "{"lat":59.6150515,"lng":36.2876827}"\n at Connection.parseE (/home/zaker/proj/markmap/node_modules/loopback-connector-postgresql/node_modules/pg.js/lib/connection.js:526:11)\n at Connection.parseMessage (/home/zaker/proj/markmap/node_modules/loopback-connector-postgresql/node_modules/pg.js/lib/connection.js:356:17)\n at Socket. (/home/zaker/proj/markmap/node_modules/loopback-connector-postgresql/node_modules/pg.js/lib/connection.js:105:22)\n at Socket.emit (events.js:95:17)\n at Socket. (stream_readable.js:764:14)\n at Socket.emit (events.js:92:17)\n at emitReadable (_stream_readable.js:426:10)\n at emitReadable (_stream_readable.js:422:5)\n at readableAddChunk (_stream_readable.js:165:9)\n at Socket.Readable.push (_stream_readable.js:127:10)"
}
}
what is the problem?

[unibasil]

Can you share your underlying DB table definition?

[mkzaker]

Table definition :
CREATE TABLE marks
(
title character varying(100),
location point,
id serial NOT NULL,
CONSTRAINT marks_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE marks
OWNER TO ranis;

data :
{
"title": "test",
"location": "36.9,59.6"
}

[raymondfeng]

Do you want to try out with #23?

Thanks,

---

Raymond Feng
Co-Founder and Architect @ StrongLoop, Inc.

StrongLoop makes it easy to develop APIs in Node, plus get DevOps capabilities like monitoring, debugging and clustering.

On Sep 12, 2014, at 4:13 AM, Mohammad Kazem Zaker notifications@github.com wrote:

CREATE TABLE marks
(
title character varying(100),
location point,
id serial NOT NULL,
CONSTRAINT marks_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE marks
OWNER TO ranis;

—
Reply to this email directly or view it on GitHub.

[slively]

@raymondfeng That fixed my issue, I'm currently using the feature/add-geopoint-support branch in my project. A merge would be awesome, thank you!

[davidcheung]

@raymondfeng That fixed my issue, I'm currently using the feature/add-geopoint-support branch in my project. A merge would be awesome, thank you!

Trying to clean up old issues, looks like it has been fixed a year ago :p Closing issue now.