Re: [GENERAL] Compile of Pgmail function fails

2006-02-12 Thread Tom Lane
indu ss <[EMAIL PROTECTED]> writes: > Still i get this error > ERROR: syntax error at or near "set" > CONTEXT: compile of PL/pgSQL function "pgmail" near > line 1 Somehow, I don't think you are passing this function to the pltcl PL... either you mistyped the language attribute, or you've manage

Re: [GENERAL] Compile of Pgmail function fails

2006-02-12 Thread indu ss
I'm using the pgmail function bundled in pgMail-1.1.tar. Tried select pgmail('<[EMAIL PROTECTED]>','<[EMAIL PROTECTED]>','Test pgmail','Test message '); Still i get this error ERROR: syntax error at or near "set" CONTEXT: compile of PL/pgSQL function "pgmail" near line 1 I have specifie

Re: [GENERAL] Compile of Pgmail function fails

2006-02-07 Thread Robert Treat
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 sta

[GENERAL] Compile of Pgmail function fails

2006-02-06 Thread indu ss
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 "pg