Doesn't work on heroku

Question

Doesn't work on heroku

letronje opened this issue 8 years ago · 3 comments

The upsert calls work locally, but on Heroku, I see this error

LINE 1: SELECT upsert2_1_2_group_conversations_SEL_id_SET_id_A_lates...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Answer 1 · 2017-03-31T22:08:45.000Z

@letronje Are you able to login to a psql shell on heroku and try creating a function yourself? I took a look over the code again and while it should throw an error (from Upsert, not PG) if the function creation fails, perhaps there's an edge-case that's been missed.

Answer 2 · 2017-04-20T12:36:12.000Z

@letronje can you provide a fuller backtrace?

Answer 3 · 2017-04-21T08:22:13.000Z

Hey sorry about the delay. I think restarting the dyno helped. works now.