Re: Oracle database into PostgreSQL using Ora2PG tool.

On Sat, Jun 3, 2017 at 1:48 AM, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:

>
> I wonder, does plpgsql compilation check for existence of the
> add_job_history function or is that a runtime check?
>
> ____________________________________________________________________
>
> At runtime.
>
>

Hi Neyman,

Thanks it's done by adding PERFORM.

DROP TRIGGER IF EXISTS update_job_history ON employees CASCADE;

CREATE OR REPLACE FUNCTION trigger_fct_update_job_history() RETURNS trigger
AS $BODY$

BEGIN

PERFORM add_job_history(OLD.employee_id, OLD.hire_date, LOCALTIMESTAMP,

OLD.job_id, OLD.department_id);

RETURN NEW;

END

$BODY$

LANGUAGE 'plpgsql';