unable to cerate uniqie index on macaddr !

From: Pawel Pierscionek <pawel(at)astercity(dot)net>
To: pgsql-general(at)postgreSQL(dot)org
Subject: unable to cerate uniqie index on macaddr !
Date: 1999-01-30 10:14:00
Message-ID: 12468.990130@astercity.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

create dhcp
(
mac macaddr,
ip inet4
);

I fill it with unique mac,ip pairs and do

select * from dhcp;
...
(493 rows)

select * from dhcp group by mac;
...
(493 rows)

select distinct on mac mac from dhcp group by mac;
...
(493 rows)

create unique index dhcp_mac on dhcp (mac)
ERROR: Cannot create unique index. Table contains non-unique values

Any clue ?
Table is freshly created;
Db is after a vacuum.

TIA,
Pawel Pierscionek

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Reinke 1999-01-30 15:39:31 Inaccessible table??
Previous Message Robert Chalmers 1999-01-30 07:03:42 Dashed if I can work this out. Help needed copying substring to another field