I just cut and pasted someone's mac address:

patrimoine=# update ethernet set mac='00-00-39-AB-92-FO' where id=623;
UPDATE 1
patrimoine=# select mac from ethernet where id=623;
        mac        
-------------------
 00:00:39:ab:92:0f
(1 row)


Note the typo "O" instead of "0". I can see how that happened - should it
be "notify"ed against?

(pre-25 Sept code, 7.3b1)

Cheers,

Patrick

Sun, 13 Oct 2002 14:16:09 +0100
Patrick Welche <prlw1@newn.cam.ac.uk>
mac typo prob?
Patrick Welche <prlw1@newn.cam.ac.uk> writes:
> I just cut and pasted someone's mac address:
> patrimoine=# update ethernet set mac='00-00-39-AB-92-FO' where id=623;
> UPDATE 1
> patrimoine=# select mac from ethernet where id=623;
>         mac        
> -------------------
>  00:00:39:ab:92:0f
> (1 row)


> Note the typo "O" instead of "0". I can see how that happened - should it
> be "notify"ed against?

No, it should be an error IMHO.  macaddr_in() is failing to check for
trailing junk, which is a standard problem for sscanf-based parsing...

			regards, tom lane

Sun, 13 Oct 2002 10:55:44 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: mac typo prob? 