Duncan,
>
> wireman=# insert into loc values (1,1,'HELP');
> ERROR: Cannot insert a duplicate key into unique index loc_pkey
Try this instead:
INSERT INTO loc ( building_key, floor, ref )
VALUES (1, 1, 'Help');
Explicit column naming in INSERTs is always a good idea.
Also, upgrading to 7.1.3 would be a good idea, although unrelated to
your problem.
Finally, SERIAL and NEXTVAL sequences do not work properly in older
versions of pgODBC, if you're using a WIndows client. Upgrading to the
new pgAdmin will solve this.
-Josh Berkus