Re: Oracle database into PostgreSQL using Ora2PG tool.

[PAWAN SHARMA <er.pawanshr0963@xxxxxxxxx>]

On Sat, Jun 3, 2017 at 1:48 AM, Igor Neyman <ineyman@xxxxxxxxxxxxxx> 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';