I get an error when doing multiple deletes on the database (Postgres, OS X, Docker, Node JS)
No clue if this is a bug or other error. Just wondering if others have experienced it.
I select table rows with a checkbox and submit to a server action that contains a repeat and deletes every id that gets passed
It works fine and runs a db delete for all the items in the array from index 0 up to and including 20.
SO I can delete the first 21 items , but it always fails on the 22 item ?
Does not make sense that the item with index 21 should be of any other datatype the the preceding
id’s
From my PG log
2020-07-14 20:15:13.721 UTC [3855] ERROR: invalid input syntax for integer: "{"21":"491"}"
2020-07-14 20:15:13.721 UTC [3855] STATEMENT: delete from "ccu" where "ccu_id" = $1
2020-07-14 20:18:40.731 UTC [3870] ERROR: invalid input syntax for integer: "{"21":"511"}"
2020-07-14 20:18:40.731 UTC [3870] STATEMENT: delete from "ccu" where "ccu_id" = $1
2020-07-14 20:19:17.298 UTC [3879] ERROR: invalid input syntax for integer: "{"21":"532"}"
2020-07-14 20:19:17.298 UTC [3879] STATEMENT: delete from "ccu" where "ccu_id" = $1
2020-07-14 20:28:49.335 UTC [3943] ERROR: invalid input syntax for integer: "{"21":"77"}"
2020-07-14 20:28:49.335 UTC [3943] STATEMENT: delete from "ccu" where "ccu_id" = $1
Community Page
Last updated:
Last updated: