I have just started using EMS ProstgresSQL Manager. I have already created a function which I would like to use in a trigger.

The Problem:

When creating a trigger and during compilation I get the message that the function does not exist, but it does and it works too. All my objects reside in the Public Schema and I do put in references like public.product in the create trigger code.

Can anyone provide me with advice as to what I could possibly be doing wrong?

Thank You