Thread: error calling pgmail function

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.

Thanks

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

indu ss <ind1_us@yahoo.com> writes:
> 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

Uh, you didn't show us the actual error, nor the problematic line
within pgmail.  (The reference to function "test" is just a stack
back-trace of how you got to pgmail; it does not imply that that's
where the error is.)

            regards, tom lane