agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Andreas Joseph Krogh <andreas@visena.com>
To: Steve Midgley <science@misuse.org>
Cc: pgsql-sql@lists.postgresql.org
Subject: Re: FW: Re: type for storing emails?
Date: Tue, 12 Nov 2019 17:44:52 +0100 (CET)
Message-ID: <VisenaEmail.3b.a983a8bb456c831f.16e6080d141@tc7-visena> (raw)
In-Reply-To: <CAJexoSK2164CXFF_82u=OufPTh0Hk2F_YLSKE6_4hq4-TN2e-A@mail.gmail.com>
På tirsdag 12. november 2019 kl. 16:50:35, skrev Steve Midgley <
science@misuse.org <mailto: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
view thread (7+ messages)
Message-ID: <VisenaEmail.3b.a983a8bb456c831f.16e6080d141@tc7-visena>
Permalink: ../VisenaEmail.3b.a983a8bb456c831f.16e6080d141@tc7-visena/
Also on: postgresql.org/message-id/VisenaEmail.3b.a983a8bb456c831f.16e6080d141@tc7-visena
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andreas@visena.com, science@misuse.org, pgsql-sql@lists.postgresql.org
Subject: Re: FW: Re: type for storing emails?
In-Reply-To: <VisenaEmail.3b.a983a8bb456c831f.16e6080d141@tc7-visena>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox