Re: Postgre RAISE NOTICE and PHP - Mailing list pgsql-general

From Sam Mason
Subject Re: Postgre RAISE NOTICE and PHP
Date
Msg-id 20090820131616.GY5407@samason.me.uk
Whole thread Raw
In response to Re: Postgre RAISE NOTICE and PHP  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-general
On Thu, Aug 20, 2009 at 01:03:47PM +0000, Jasen Betts wrote:
> On 2009-08-20, Randal L. Schwartz <merlyn@stonehenge.com> wrote:
> > Exactly!  If you don't want to use the 950-character regex, DON'T DO
> > ANYTHING AT ALL.  Far simpler.
>
> Or do an MX lookup on the domain part (or a partial attempt to route
> mail*) before sending it to the database.
>
> *contact the domains MX and in SMTP go as far as "RCPT TO: ... " and
> then send "QUIT" after it is accepted or refused.

Why not just go the whole way and send an email asking for confirmation?
When you get a response you know the email address is actually useful
for contacting the user, rather than it being a typo and going somewhere
else.

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Postgre RAISE NOTICE and PHP
Next
From: Jasen Betts
Date:
Subject: Re: PL/PGSQL: why IF test the whole condition before failing or not?