| 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: | Whole Thread | Raw Message | 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? |