[HACKERS] mac typo prob?

[Patrick Welche]

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 notifyed against?

(pre-25 Sept code, 7.3b1)

Cheers,

Patrick

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [HACKERS] mac typo prob?

[Tom Lane]

Patrick Welche [EMAIL PROTECTED] 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 notifyed 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

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]