The syntax for insertion could be like
insert into loc (bulding_key,floor,ref) values (1,1 'help');
If you have dropped table, it would be necessary to drop
key_location_seq explicitly.
Vijay
"Duncan Adams (DNS)" wrote:
>
> Hi
>
> I really need help on this one. can any one please explain to me how
> "SERIAL PRIMARY KEY "
>
> wireman=# insert into loc values (1,1,'HELP');
> ERROR: Cannot insert a duplicate key into unique index loc_pkey