malformed array literal

[Qinka]

I inserted a row of data, and got the followed error.

SqlError {sqlState = \"22P02\", sqlExecStatus = FatalError, sqlErrorMsg = \"malformed array literal: \\\"[1,1,1]\\\"\", sqlErrorDetail = \"Missing \\\"]\\\" after array dimensions.\", sqlErrorHint = \"\"}

And my Postgres has such output:

ERROR:  malformed array literal: "[1,1,1]" at character 200
DETAIL:  Missing "]" after array dimensions.
STATEMENT:  INSERT INTO "table_task_info"("key_tid","key_ew","key_ns","key_r","key_wei","key_size","key_note","key_cost","key_des") VALUES('T2016-06-048c330b133d149fd972ad0bd700e5664bb71e1cf1',1.0,1.0,100.0,1.0,'[1,1,1]',null,100,null)

[Qinka]

I don't know whether I used PostgreSQL array and persistent in a wrong way, but to seemed that some functions is not suitable.

I don't know why array is transformed to JSON's array but not to SQL's array. However, it do.

[gregwebs]

Are you using persistent for migrations?

[Qinka]

I just use insert function.

[Qinka]

I think listToJSON (at Database/Persist/PostgreSQL.hs:line:305 ) should be changed to PG.PGArray.

And if you think it's necessary, I will fork and send a new pull request.

[gregwebs]

PR would be great.

[Qinka]

Sorry, I'm not good at English, and what does PR stand for?

[psibi]

Pull Request. :)

[Qinka]

😂

[MaxGabriel]

For the longest time I thought "LGTM" meant "Let's get this merged"

[parsonsmatt]

persistent-postgresql-2.10.0 supports arrays with the new PersistArray :: [PersistValue] -> PersistValue constructor. #884