hugsql

Danny Almeida 2019-07-28T07:51:06.003800Z

doesn't :n specify the columns affected by the query ? The above error indicates that postgresql does not return the rows affected and this might be the reason for the error message

Ahmed Hassan 2019-07-28T07:51:43.004200Z

@dionysius.almeida so problem is with Postgresql?

Danny Almeida 2019-07-28T07:51:58.004500Z

not sure..try with :n in the query

Danny Almeida 2019-07-28T07:52:21.005300Z

or run the sql command directly in postgres and see if you get an error

Danny Almeida 2019-07-28T07:52:33.005700Z

without :n

Ahmed Hassan 2019-07-28T07:52:36.005900Z

http://www.postgresqltutorial.com/postgresql-delete/ here postgres returns no. of affected rows.

Danny Almeida 2019-07-28T07:55:14.007400Z

maybe see what sql your query is producing and run that sql directly in postgresql and if you get the same error

Ahmed Hassan 2019-07-28T07:58:44.007900Z

mydb=# DELETE FROM mytable; DELETE 3

Ahmed Hassan 2019-07-28T08:01:08.008900Z

It returned No. of rows affected.