From: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgre RAISE NOTICE and PHP |
Date: | 2009-08-20 13:16:16 |
Message-ID: | 20090820131616.GY5407@samason.me.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Aug 20, 2009 at 01:03:47PM +0000, Jasen Betts wrote:
> On 2009-08-20, Randal L. Schwartz <merlyn(at)stonehenge(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2009-08-20 13:28:24 | Re: PL/PGSQL: why IF test the whole condition before failing or not? |
Previous Message | Jasen Betts | 2009-08-20 13:03:47 | Re: Postgre RAISE NOTICE and PHP |