I presume threre is a query which check for the function/trigger existence? Something like: IF NOT EXIST(SELECT * FROM ) CREATE OR REPLACE FUNCTION....;
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных