Re: Functions and triggers can anyone help

I know nothing about PgAdmin-II so can't really help there. One thing you
should be aware of though is that in postgresql 7.3 functions for as triggers
have a return type of trigger not opaque. It could be that that is what is
causing your problem if you have a recent server.

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

> 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
k