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,
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? |