Re: Functions and triggers can anyone help

I have read through all the docs on triggers and functions.
I'm using pgadminII to setup the trigger. It says that the function I have
created does not exist. This is after you can select it. I can see the
function there. I don't know if my function is correct. It did compile and
was created but I'm not sure it is in the correct format for a trigger to be
able to use it.

This is a little different than oracle. I have no problems using this
function and trigger in Oracle. Please Help
I would like to convert over to Postgresql because what I have seen of it. I
believe it could be a lot faster then oracle in the long run. If setup
correctly

thanks

-----Original Message-----
From: Nigel J. Andrews [mailto:nandrews(at)investsystems(dot)co(dot)uk]
Sent: Wednesday, February 05, 2003 9:35 AM
To: RobertD(dot)Stewart(at)mail(dot)state(dot)ky(dot)us
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Functions and triggers can anyone help

On Wed, 5 Feb 2003 RobertD(dot)Stewart(at)mail(dot)state(dot)ky(dot)us wrote:

> I'm having a problem with setting up a function and a trigger for one of
me
> tables. I have just started using Postgresql and I'm trying to convert my
> Oracle database over to see how it runs.
> ...
>
> And Here is my Postgresql function but when I try to set the trigger it
says
> it can't find the function (it does not exist)
> ...

But how are you trying to set the trigger. You included the function
definition, which I presume is created ok but haven't looked at, where as
you've not included the command that is failing.

You're obviously fairly technical, have you checked the reference manual in
the
documentation for the correct form of create trigger?

http://developer.postgresql.org/docs/postgres/sql-createtrigger.html

--
Nigel J. Andrews