Question: Can we create a trigger to call another DB instance stored procedure?

Question

Can we create a trigger to call another DB instance stored procedure?

Answers 0
Added at 2016-12-19 19:12
Tags
Question

I'm trying to call the stored procedure which is in another PostgreSQL database instance of same server, but I couldn't able to call that.

I'm using the following code.

CREATE TRIGGER add_log_trigger
 AFTER INSERT
 ON log_tbl
 FOR EACH ROW
 EXECUTE PROCEDURE ckschema.integration_fn();

Error : ckschema doesn't exist.

Answers to

Can we create a trigger to call another DB instance stored procedure?

Source Show
◀ Wstecz