macaddr stuff !

From: Pawel Pierscionek <pawel(at)astercity(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: macaddr stuff !
Date: 1999-03-21 23:57:24
Message-ID: 039.990322@astercity.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 on macaddr 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);
insert int 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,

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Davis 1999-03-22 01:52:07 RE: [HACKERS] min() and max() causing aborts
Previous Message Silvia_Brown9 1999-03-21 22:45:12 Find Out What The Future Holds For You?