title: How to fix 'SQLSTATE[42883]: Undefined function: 7 ERROR' on postgres?
body: <p>I hava a function trigger that feed a column with a geometry converted from another column with json. It was working without problems until recently, when i started getting this error: ' SQLSTATE[42883]: Undefined function: 7 ERROR ...  No function matches the given name and argument types. You might need to add explicit type casts.'</p>
  
  <p>This is the script for my function: </p>
  
  <pre><code>CREATE OR REPLACE FUNCTION update_formulario_ep()
  RETURNS trigger AS $teste_trigger$
  BEGIN
  UPDATE formulario.formulario_ep
  SET geom = (SELECT ST_GeomFromText( ST_AsText( CAST(ST_GeomFromGeoJSON(geom_js) AS TEXT) ), 4326 ));
  RETURN NEW;
  END;
  $teste_trigger$ LANGUAGE plpgsql;
  </code></pre>
  
  <p>And this is the script for the trigger:</p>
  
  <pre><code>CREATE TRIGGER update_allrows_trigger_ep
  AFTER INSERT ON formulario.formulario_ep
  FOR EACH ROW
  EXECUTE PROCEDURE update_formulario_ep();
  </code></pre>