bcgov / sbc-pay

ServiceBC common payment services for one-time and long-enagement partners
Apache License 2.0
8 stars 39 forks source link

Routing Slip Search - Cast to numeric for balance for PG8000 adapter #1619

Closed seeker25 closed 3 months ago

seeker25 commented 3 months ago

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of the sbc-pay license (Apache 2.0).

Fixes:

sqlalchemy.exc.ProgrammingError: (pg8000.dbapi.ProgrammingError) {'S': 'ERROR', 'V': 'ERROR', 'C': '42883', 'M': 'operator does not exist: numeric = character varying', 'H': 'No operator matches the given name and argument types. You might need to add explicit type casts.', 'P': '1404', 'F': 'parse_oper.c', 'L': '647', 'R': 'op_error'}