BUG #12320: json parsing with embedded double quotes
| От | postgres@bt-r.com |
|---|---|
| Тема | BUG #12320: json parsing with embedded double quotes |
| Дата | |
| Msg-id | 20141222205248.11503.72633@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #12320: json parsing with embedded double quotes
|
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 12320
Logged by: Aaron Botsis
Email address: postgres@bt-r.com
PostgreSQL version: 9.4.0
Operating system: Mac OSX
Description:
postgres=# create table ct (data jsonb);
CREATE TABLE
postgres=# copy ct (data) from '/Users/aaron/Desktop/queries.json';
ERROR: invalid input syntax for type json
DETAIL: Token "root" is invalid.
CONTEXT: JSON data, line 1: ...1418066241619 AND <=1418671041621) AND
user:"root...
COPY ct, line 3, column data:
"{"timestamp":"2014-12-15T19:17:32.505Z","duration":7.947,"query":{"query":{"filtered":{"filter":{"qu..."
This is a sample of the JSON:
{"timestamp":"2014-12-15T19:17:32.505Z","duration":7.947,"query":{"query":{"filtered":{"filter":{"query":{"query_string":{"query":"organization_id:[REDACTED]
AND timestamp:(>=1418066241619 AND <=1418671041621) AND
user:\"root\""}}}}},"from":0,"size":20,"timeout":10000,"sort":{"timestamp":{"order":"desc"}},"facets":{}},"organization_id":"[REDACTED]","indices":["logs.[REDACTED].20141209","logs.[REDACTED].20141208","logs.[REDACTED].20141215","logs.[REDACTED].20141210","logs.[REDACTED].20141213","logs.[REDACTED].20141214","logs.[REDACTED].20141211","logs.[REDACTED].20141212"],"type":"all","level":"info","message":""}
В списке pgsql-bugs по дате отправления: