On Monday 06 February 2006 01:12, indu ss wrote:
> Hello,
>
> I want to send mail on update of a field in a table.
> I'm using pgmail() function (from sourceforge) . I'm
> calling this function from another function which is
> called by trigger on update of the field.
> On executing the update statement i get error
>
> CONTEXT: compile of PL/pgSQL function "pgmail" near
> line 1
> PL/pgSQL function "test" line 10 at assignment
>
> The line 10 corresponds to the line where pgmail
> function is called.
>
> pos := pgmail(p1,p2,p3,p4);
>
>
> Can anyone help me? I'm using postgres 7.4.7 version.
Try to run pgmail by itself with those values and see what error that gives
you.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL