Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

On Feb 17, 2008 7:47 AM, Jorge Godoy [EMAIL PROTECTED] wrote: Em Friday 15 February 2008 12:36:37 Adam Rich escreveu: I would instead queue messages (or suitable information about them) in a table, and have a process outside PostgreSQL periodically poll for them Why poll when you can

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

Em Friday 15 February 2008 12:36:37 Adam Rich escreveu: I would instead queue messages (or suitable information about them) in a table, and have a process outside PostgreSQL periodically poll for them Why poll when you can wait?

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

On 2/14/08, hewei [EMAIL PROTECTED] wrote: Can send email from stored procedure in Postgres? In principle, yes, using one of the untrusted stored function languages. pl/perl, pl/sh, pl/python, and such. I wouldn't do things that way... I would instead queue messages (or suitable information

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

I would instead queue messages (or suitable information about them) in a table, and have a process outside PostgreSQL periodically poll for them Why poll when you can wait? http://www.postgresql.org/docs/8.2/interactive/sql-notify.html ---(end of

[GENERAL] the feasibility of sending email from stored procedure in Postgres

Can send email from stored procedure in Postgres?

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

On Fri, 15 Feb 2008 11:59:19 +0800 hewei [EMAIL PROTECTED] wrote: Can send email from stored procedure in Postgres? Sure, see plperl. Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

Joshua D. Drake wrote: On Fri, 15 Feb 2008 11:59:19 +0800 hewei [EMAIL PROTECTED] wrote: Can send email from stored procedure in Postgres? Sure, see plperl. There was also this: http://sourceforge.net/projects/pgmail/ but no idea whether it's being maintained. -- Postgresql php

[GENERAL] the feasibility of sending email from stored procedure in Postgres

Hello pgsql-general, Can send email from stored procedure in Postgres ? Best regards, william [EMAIL PROTECTED] 2008-02-15 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

am Fri, dem 15.02.2008, um 11:39:53 +0800 mailte william folgendes: Hello pgsql-general, Can send email from stored procedure in Postgres ? Of course, there are several solutions. For instance, use an untrusted language like pl/perlU or pl/sh. Other solution: pgmail from