Re: FW: Re: type for storing emails? - Mailing list pgsql-sql

From Andreas Joseph Krogh
Subject Re: FW: Re: type for storing emails?
Date
Msg-id VisenaEmail.3b.a983a8bb456c831f.16e6080d141@tc7-visena
Whole thread Raw
In response to Re: FW: Re: type for storing emails?  (Steve Midgley <science@misuse.org>)
List pgsql-sql
På tirsdag 12. november 2019 kl. 16:50:35, skrev Steve Midgley <science@misuse.org>:
[...]
Not to be pedantic but in the data model, you could have a couple of verification data fields (e.g. verification_code; email_verified), and actually send an email and record if the user comes back with the correct verification code. It's obviously not something that can be handled solely via specs or database, but a data model can accommodate actual email verification (as I know you know, but thought I should make clear for future readers of the archives).
 
My point is;  There is no way to tecnichally verify that an email actually «exists» (as in being active and will be routed to an actual recipient). Yes, you can do all sorts of acrobatics, and may in many attempts succeed, but there exists no method guaranteeing this. Many email-servers will for example happily receive the email, respond "OK, got it", but throw the email in an "unknown recipients"-bin, effectively ignoring any email sent to a non-existing address.
 
--
Andreas Joseph Krogh

pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: FW: Re: type for storing emails?
Next
From: stan
Date:
Subject: install problem with extensions