 

> -----Original Message-----
> From: Steve Atkins [mailto:steve@blighty.com] 
> Sent: 17 May 2004 16:46
> To: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Email data type
> 
> a@foo.bar is syntactically valid. a@foo.invalid is 
> syntactically valid, but should be immediately rejected. 

I disagree - just because the database server cannot verify the the
existence of a domain does not mean that it isn't valid. I think only
addresses that are syntactically incorrect should be rejected.

Regards, Dave.

Mon, 17 May 2004 17:01:05 +0100
"Dave Page" <dpage@vale-housing.co.uk>
Re: Email data type
On Mon, May 17, 2004 at 05:01:05PM +0100, Dave Page wrote:

> > a@foo.bar is syntactically valid. a@foo.invalid is 
> > syntactically valid, but should be immediately rejected. 
> 
> I disagree - just because the database server cannot verify the the
> existence of a domain does not mean that it isn't valid. I think only
> addresses that are syntactically incorrect should be rejected.

I think you're missing the point. Go and take a glance at RFC 2606 -
it's a BCP which defines the .test, .invalid, .example and .localhost
TLDs.

Of course, some users may want to use .invalid email addresses in
their database, despite their being, by definition, invalid. It's
something that will vary depending on their needs.

Cheers,
  Steve


Mon, 17 May 2004 09:22:20 -0700
Steve Atkins <steve@blighty.com>
Re: Email data type
It's rumoured that Steve Atkins once said:
> On Mon, May 17, 2004 at 05:01:05PM +0100, Dave Page wrote:
>
>> > a@foo.bar is syntactically valid. a@foo.invalid is
>> > syntactically valid, but should be immediately rejected.
>>
>> I disagree - just because the database server cannot verify the the
>> existence of a domain does not mean that it isn't valid. I think only
>> addresses that are syntactically incorrect should be rejected.
>
> I think you're missing the point. Go and take a glance at RFC 2606 -
> it's a BCP which defines the .test, .invalid, .example and .localhost
> TLDs.

Ahh, yes - clearly I was missing the point :-)

Regards, Dave.



Mon, 17 May 2004 18:55:16 +0100 (BST)
"Dave Page" <dpage@vale-housing.co.uk>
Re: Email data type