Re: [GENERAL] Postgre RAISE NOTICE and PHP
On Thu, Aug 20, 2009 at 21:52, Jasen Betts wrote:
> On 2009-08-19, Clemens Schwaighofer wrote:
>> On Wed, Aug 19, 2009 at 02:11, Randal L. Schwartz
>> wrote:
"Andre" == Andre Lopes writes:
>>>
>>> Andre> I'm developing a function with some checks, for example... to check
>>> if the
>>> Andre> e-mail is valid or not.
>>>
>>> How are you hoping to do this? The regex to validate an email
>>> address syntactically is pretty large:
>>>
>>> http://ex-parrot.com/~pdw/Mail-RFC822-Address.html
>>>
>>> And no, I'm not kidding. If your regex is smaller than that, you aren't
>>> validating email... you're validating something "kinda like email".
>>
>> Just in my opinion, this regex is completely too large. For basic
>> validating something like:
>> ^[A-Za-z0-9!#$%&'*+-\/=?^_`{|}~][A-Za-z0-9!#$%&'*+-\/=?^_`{|}~\.]{0,6...@[a-za-z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,4}){1}$
>> works very well
>
> not good: eg:
>
> fails this valid address* : ad...@xxx.museum
yes it does, but all I need to change is {2,4}, to {2,6} or {2,}
> accepts this invalid one : y...@gmail..com
and not it does not. I just tested it here.
The regex helps to avoid stuff like this:
f...@bar.com
foo@@bar.com
f...@.bar.com
f...@bar
etc
>
> "musedoma" replaced with several x to protect the innocent from spam
>
> in some contexts email adrresses with no domain part are valid
> addresses with [bracketed] mx servers instead of a domain and/or bang
> paths are also allowed (but not in common use and often not desirable)
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
★ Clemens 呉 Schwaighofer
★ IT Engineer/Web Producer/Planning
★ E-Graphics Communications SP Digital
★ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN
★ Tel: +81-(0)3-3545-7706
★ Fax: +81-(0)3-3545-7343
★ http://www.e-gra.co.jp
This e-mail is intended only for the named person or entity to which it is
addressed and contains valuable business information that is privileged,
confidential and/or otherwise protected from disclosure. If you received this
e-mail in error, any review, use, dissemination, distribution or copying of
this e-mail is strictly prohibited. Please notify us immediately of the error
via e-mail to disclai...@tbwaworld.com and please delete the e-mail from your
system, retaining no copies in any media.We appreciate your cooperation.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
On Thu, Aug 20, 2009 at 01:03:47PM +, Jasen Betts wrote: > On 2009-08-20, Randal L. Schwartz 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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
On 2009-08-20, Randal L. Schwartz wrote: >> "Clemens" == Clemens Schwaighofer >> writes: > >Clemens> I am not going to defend any regex here, but in my opinion it helps on >Clemens> what I want to see in email addresses. >Clemens> Yes it fails on mobile, but I have not yet seen one. > > And that's the problem. You get near-sighted if you put up a strong > validation for only things that *you* have seen. Because, guess what, > nobody outside your narrow view can sign up or be a customer. > > Bad for business. > >Clemens> Probably the best >Clemens> thing is to test nothing at all. Just accept it ... > > 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
On 2009-08-19, Clemens Schwaighofer wrote:
> On Wed, Aug 19, 2009 at 02:11, Randal L. Schwartz
> wrote:
>>> "Andre" == Andre Lopes writes:
>>
>> Andre> I'm developing a function with some checks, for example... to check
>> if the
>> Andre> e-mail is valid or not.
>>
>> How are you hoping to do this? The regex to validate an email
>> address syntactically is pretty large:
>>
>> http://ex-parrot.com/~pdw/Mail-RFC822-Address.html
>>
>> And no, I'm not kidding. If your regex is smaller than that, you aren't
>> validating email... you're validating something "kinda like email".
>
> Just in my opinion, this regex is completely too large. For basic
> validating something like:
> ^[A-Za-z0-9!#$%&'*+-\/=?^_`{|}~][A-Za-z0-9!#$%&'*+-\/=?^_`{|}~\.]{0,6...@[a-za-z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,4}){1}$
> works very well
not good: eg:
fails this valid address* : ad...@xxx.museum
accepts this invalid one : y...@gmail..com
"musedoma" replaced with several x to protect the innocent from spam
in some contexts email adrresses with no domain part are valid
addresses with [bracketed] mx servers instead of a domain and/or bang
paths are also allowed (but not in common use and often not desirable)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
On 08/19/2009 11:41 PM, Randal L. Schwartz wrote:
>> "Clemens" == Clemens Schwaighofer
>> writes:
>
> Clemens> Just in my opinion, this regex is completely too large. For basic
> Clemens> validating something like:
> Clemens>
> ^[A-Za-z0-9!#$%&'*+-\/=?^_`{|}~][A-Za-z0-9!#$%&'*+-\/=?^_`{|}~\.]{0,6...@[a-za-z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,4}){1}$
> Clemens> works very well
>
> Fails on ".mobile" TLD. Has a pointless {1} in it, which does
> absolutely nothing, providing that the creator of the regex was already
> missing a few clues.
>
> That's the problem with these kinds of regex... you test it on what
> you know, but you're not consulting the *actual* *internet* specifications
> (which have been readily available since the dawn of Internet time).
>
> Either use the regex I pointed to already, or stay with the simpler:
>
> /\...@.*\s/
>
> which will at least not deny anyone with a *perfectly legitimate* email
> address from making it into your system.
>
> Or, use your regex *only* in an *advice* category, with the ability
> for the user to say "yes, I'm really sure this is my address".
>
> Please, for the sake of the net, do the Right Thing here. This is
> what I'm arguing for. Anything less than that, and your code deserves
> to end up in thedailywtf.com as an example of what *not* to do.
I am not going to defend any regex here, but in my opinion it helps on
what I want to see in email addresses.
Yes it fails on mobile, but I have not yet seen one. Probably the best
thing is to test nothing at all. Just accept it ...
--
[ Clemens Schwaighofer -=:~ ]
[ IT Engineer/Web Producer/Planning ]
[ E-Graphics Communications SP Digital ]
[6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ]
[ Tel: +81-(0)3-3545-7706Fax: +81-(0)3-3545-7343 ]
[ http://www.e-gra.co.jp ]
signature.asc
Description: OpenPGP digital signature
Re: [GENERAL] Postgre RAISE NOTICE and PHP
> "Clemens" == Clemens Schwaighofer > writes: Clemens> I am not going to defend any regex here, but in my opinion it helps on Clemens> what I want to see in email addresses. Clemens> Yes it fails on mobile, but I have not yet seen one. And that's the problem. You get near-sighted if you put up a strong validation for only things that *you* have seen. Because, guess what, nobody outside your narrow view can sign up or be a customer. Bad for business. Clemens> Probably the best Clemens> thing is to test nothing at all. Just accept it ... Exactly! If you don't want to use the 950-character regex, DON'T DO ANYTHING AT ALL. Far simpler. -- Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 http://www.stonehenge.com/merlyn/> Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc. See http://methodsandmessages.vox.com/ for Smalltalk and Seaside discussion -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
On Wed, Aug 19, 2009 at 11:57:45AM -0600, Scott Marlowe wrote:
> On Wed, Aug 19, 2009 at 8:41 AM, Randal L.
> Schwartz wrote:
> >> "Clemens" == Clemens Schwaighofer
> >> writes:
> >
> > Clemens> Just in my opinion, this regex is completely too large. For basic
> > Clemens> validating something like:
> > Clemens>
> > ^[A-Za-z0-9!#$%&'*+-\/=?^_`{|}~][A-Za-z0-9!#$%&'*+-\/=?^_`{|}~\.]{0,6...@[a-za-z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,4}){1}$
> > Clemens> works very well
> >
> > Fails on ".mobile" TLD. Has a pointless {1} in it, which does
> > absolutely nothing, providing that the creator of the regex was already
> > missing a few clues.
>
> Remonds me of the saying that for every complex problem there is a
> simple, elegant and incorrect solution.
That's from H. L. Mencken.
For every complex problem, there is an answer which is clear,
simple, and wrong.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
On Wed, Aug 19, 2009 at 8:41 AM, Randal L.
Schwartz wrote:
>> "Clemens" == Clemens Schwaighofer
>> writes:
>
> Clemens> Just in my opinion, this regex is completely too large. For basic
> Clemens> validating something like:
> Clemens>
> ^[A-Za-z0-9!#$%&'*+-\/=?^_`{|}~][A-Za-z0-9!#$%&'*+-\/=?^_`{|}~\.]{0,6...@[a-za-z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,4}){1}$
> Clemens> works very well
>
> Fails on ".mobile" TLD. Has a pointless {1} in it, which does
> absolutely nothing, providing that the creator of the regex was already
> missing a few clues.
Remonds me of the saying that for every complex problem there is a
simple, elegant and incorrect solution.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
On Wed, Aug 19, 2009 at 02:11, Randal L. Schwartz wrote:
>> "Andre" == Andre Lopes writes:
>
> Andre> I'm developing a function with some checks, for example... to check if
> the
> Andre> e-mail is valid or not.
>
> How are you hoping to do this? The regex to validate an email
> address syntactically is pretty large:
>
> http://ex-parrot.com/~pdw/Mail-RFC822-Address.html
>
> And no, I'm not kidding. If your regex is smaller than that, you aren't
> validating email... you're validating something "kinda like email".
Just in my opinion, this regex is completely too large. For basic
validating something like:
^[A-Za-z0-9!#$%&'*+-\/=?^_`{|}~][A-Za-z0-9!#$%&'*+-\/=?^_`{|}~\.]{0,6...@[a-za-z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,4}){1}$
works very well
> For example, is a valid email address. (Go
> ahead, try it... it has an autoresponder.)
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
★ Clemens 呉 Schwaighofer
★ IT Engineer/Web Producer/Planning
★ E-Graphics Communications SP Digital
★ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN
★ Tel: +81-(0)3-3545-7706
★ Fax: +81-(0)3-3545-7343
★ http://www.e-gra.co.jp
This e-mail is intended only for the named person or entity to which it is
addressed and contains valuable business information that is privileged,
confidential and/or otherwise protected from disclosure. If you received this
e-mail in error, any review, use, dissemination, distribution or copying of
this e-mail is strictly prohibited. Please notify us immediately of the error
via e-mail to disclai...@tbwaworld.com and please delete the e-mail from your
system, retaining no copies in any media.We appreciate your cooperation.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
> "Clemens" == Clemens Schwaighofer
> writes:
Clemens> Just in my opinion, this regex is completely too large. For basic
Clemens> validating something like:
Clemens>
^[A-Za-z0-9!#$%&'*+-\/=?^_`{|}~][A-Za-z0-9!#$%&'*+-\/=?^_`{|}~\.]{0,6...@[a-za-z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,4}){1}$
Clemens> works very well
Fails on ".mobile" TLD. Has a pointless {1} in it, which does
absolutely nothing, providing that the creator of the regex was already
missing a few clues.
That's the problem with these kinds of regex... you test it on what
you know, but you're not consulting the *actual* *internet* specifications
(which have been readily available since the dawn of Internet time).
Either use the regex I pointed to already, or stay with the simpler:
/\...@.*\s/
which will at least not deny anyone with a *perfectly legitimate* email
address from making it into your system.
Or, use your regex *only* in an *advice* category, with the ability
for the user to say "yes, I'm really sure this is my address".
Please, for the sake of the net, do the Right Thing here. This is
what I'm arguing for. Anything less than that, and your code deserves
to end up in thedailywtf.com as an example of what *not* to do.
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
http://www.stonehenge.com/merlyn/>
Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc.
See http://methodsandmessages.vox.com/ for Smalltalk and Seaside discussion
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
On Aug 18, 2009, at 16:45 , Scott Marlowe wrote: On Tue, Aug 18, 2009 at 10:57 AM, Andre Lopes wrote: I need to know if it is possible to show this RAISE NOTICE when I run this function from PHP. http://www.php.net/manual/en/function.pg-last-notice.php Thanks, Scott. Is there an equivalent in PDO? Looking through the docs I don't see one. It'd also be nice to be able to get at any/all of the additional information that's passed back: warning, context, hint, etc. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
Andre, See this PHP page: http://www.php.net/manual/en/function.pg-last-notice.php Andre Lopes wrote: Hi, I'm developing a function with some checks, for example... to check if the e-mail is valid or not. If the e-mail is not valid I put a line with RAISE NOTICE 'E-mail not valid'. I need to know if it is possible to show this RAISE NOTICE when I run this function from PHP. Best Regards, André. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
On Tue, Aug 18, 2009 at 10:57 AM, Andre Lopes wrote: > Hi, > > I'm developing a function with some checks, for example... to check if the > e-mail is valid or not. > > If the e-mail is not valid I put a line with RAISE NOTICE 'E-mail not > valid'. > > I need to know if it is possible to show this RAISE NOTICE when I run this > function from PHP. http://www.php.net/manual/en/function.pg-last-notice.php example plpgsql function: create or replace function tester() returns int language plpgsql as $$ BEGIN raise notice 'whoops'; return 1; END $$; example php: -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgre RAISE NOTICE and PHP
> "Andre" == Andre Lopes writes: Andre> I'm developing a function with some checks, for example... to check if the Andre> e-mail is valid or not. How are you hoping to do this? The regex to validate an email address syntactically is pretty large: http://ex-parrot.com/~pdw/Mail-RFC822-Address.html And no, I'm not kidding. If your regex is smaller than that, you aren't validating email... you're validating something "kinda like email". For example, is a valid email address. (Go ahead, try it... it has an autoresponder.) -- Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 http://www.stonehenge.com/merlyn/> Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc. See http://methodsandmessages.vox.com/ for Smalltalk and Seaside discussion -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Postgre RAISE NOTICE and PHP
Hi, I'm developing a function with some checks, for example... to check if the e-mail is valid or not. If the e-mail is not valid I put a line with RAISE NOTICE 'E-mail not valid'. I need to know if it is possible to show this RAISE NOTICE when I run this function from PHP. Best Regards, André.
