Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. EXCEPTION WHEN others THEN
  2. v_state = RETURNED_SQLSTATE,
  3. v_msg1 = MESSAGE_TEXT,
  4. v_detail = PG_EXCEPTION_DETAIL,
  5. v_hint = PG_EXCEPTION_HINT,
  6. v_context = PG_EXCEPTION_CONTEXT;
  7.  
  8.  
  9. raise notice E'Got exception:
  10. state : %
  11. message: %
  12. detail : %
  13. hint : %
  14. context: %', v_state, v_msg1, v_detail, v_hint, v_context;
  15.  
  16. ERROR: function mobile.message(integer) does not exist
  17. LINE 1: SELECT mobile.message(v_status)
  18. ^
  19. HINT: No function matches the given name and argument types. You might need to add explicit type casts.
  20. QUERY: SELECT mobile.message(v_status)
  21. CONTEXT: PL/pgSQL function mobile.blurb_stream(jsonb) line 190 at assignment
  22. ********** Error **********
  23.  
  24. ERROR: function mobile.message(integer) does not exist
  25. SQL state: 42883
  26. Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  27. Context: PL/pgSQL function mobile.blurb_stream(jsonb) line 190 at assignment
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement