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.Stewart@mail.state.ky.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@investsystems.co.uk]
> Sent: Wednesday, February 05, 2003 9:35 AM
> To: RobertD.Stewart@mail.state.ky.us
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Functions and triggers can anyone help
>
>
> On Wed, 5 Feb 2003 RobertD.Stewart@mail.state.ky.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