This is the sample table :
CREATE TABLE contacts
(
id character varying NOT NULL,
CONSTRAINT pkey_id PRIMARY KEY (id)
)
I use PHP with PostgreSQL database..if i will run my PHP code:
Example: ADD ID NUMBER <-- If i will click this, the message below will appear:
Warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "pkey_id" in ......
1. I can add id number.
2. I cannot add if duplicate id #'s...
3. I am really confused, why that the message appear even though i am not still adding id number?