September 30th, 2003, 05:06 AM
Trigger creation in Postgres
I have just started using EMS ProstgresSQL Manager. I have already created a function which I would like to use in a trigger.
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?