macaddr stuff ! - Mailing list pgsql-hackers

From Pawel Pierscionek
Subject macaddr stuff !
Date
Msg-id 039.990322@astercity.net
Whole thread Raw
Responses Re: [HACKERS] macaddr stuff !u
Re: [HACKERS] macaddr stuff !
List pgsql-hackers
Hi,
 I have no one to turn to. I've tried here & there but got no answer. Why is there is a problem creating unique indices
onmacaddr columns even if there ARE NO (checked by count on distinct,group by) duplicated keys ?
 
 And finally :
 create table tmac (i int4,mac macaddr); insert int table tmac (i) values (1); insert int table tmac (i) values (2);
insertint table tmac (i) values (3); select * from tmac where mac='01:02:03:04:05:06';
 
 I get backend termination no matter if table has indices, is vacuumed , is new or even just after the postgres
instalation.
 HELP !
 Oh, I use 6.4.2 under i386 Redhat 5.2 Linux.

Pawel Pierscionek,




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] aggregation memory leak and fix
Next
From: Michael Davis
Date:
Subject: RE: [HACKERS] min() and max() causing aborts