Error pq: function row_to_json(text) does not exist

[murilofurquim]

I'm trying to use prest and have encountered the following error when trying to insert data:
{ "error": "pq: function row_to_json(text) does not exist" }
The GET request works fine, returning data correctly.

I'm using docker for both postgres and prest, both their latest tags.

Here is the prest docker log:
2021/11/05 20:14:02 [msg] tables.go:225 pq: function row_to_json(text) does not exist
[negroni] 2021-11-05T20:14:02Z | 400 | 794.8µs | localhost:3000 | POST /postgres/public/operacao

[avelino]

@murilofurquim can you describe your environment?

• postgresql version
• prest version

with this we can simulate your environment here

[arxdsilva]

row_to_json usage:

prest/adapters/postgres/postgres.go

Line 814 in 9a14c81

SQL = fmt.Sprintf(`%s RETURNING row_to_json("%s")`, SQL, tableName[2])

[avelino]

@murilofurquim what version of postgres are you using?

the row_to_json function that prestd uses is from postgres itself

[murilofurquim]

I have used the python library as a small web server on a script. But I can't find the source code on my PC. And can't find the example on the prest site. Can you point me to it? I can only find the documentation on the docker image. Em qua., 26 de jan. de 2022 18:46, Avelino ***@***.***> escreveu:

…

@murilofurquim <https://github.com/murilofurquim> what version of postgres are you using? the row_to_json function that prestd uses is from postgres itself — Reply to this email directly, view it on GitHub <#623 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AETL6PE4Z6NFQU65DGFWEZLUYBTSHANCNFSM5HOT3LHQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[arxdsilva]

Closing as it is stale and probably related to the postgres version used.

Msg again with more info so we can debug better and reopen.