Re: Postgre RAISE NOTICE and PHP

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/