Re: 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