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