duplicate key violates unique constraint
| От | ON.KG | 
|---|---|
| Тема | duplicate key violates unique constraint | 
| Дата | |
| Msg-id | 10813889593.20050613202239@on.kg обсуждение исходный текст | 
| Ответ на | Re: [SQL] Permission denied for language pltclu ("Dinesh Pandey" <dpandey@secf.com>) | 
| Ответы | Re: duplicate key violates unique constraint Re: duplicate key violates unique constraint | 
| Список | pgsql-general | 
Hi All!
I have table:
CREATE TABLE table1 (
   ip char(15) NOT NULL,
   hits integer NOT NULL default '1',
   PRIMARY KEY (ip)
);
So it's counting hits per each IP for current day and every day
trancated by cron:
TRUNCATE TABLE table1;
before inserting or updating this table there're some checkings,
logs, etc., so I'm using PL/PgSQL for that
after all checkings and logs I have:
      UPDATE table1
      SET hits = hits + 1
      WHERE ip = some_ip;
      IF NOT FOUND THEN
         INSERT INTO table1
            (ip)
         VALUES
            (some_ip);
      END IF;
when IP is not found in table it inserts new record into table
but in logs i see error
ERROR:  duplicate key violates unique constraint "table1"
CONTEXT:  PL/pgSQL function "insert_table1" line 68 at SQL statement
But record is inserted into table
what may be the problem?
i also tried before:
      SELECT INTO cnt hits
      FROM table1
      WHERE ip = some_ip;
      IF FOUND THEN
         UPDATE table1
         SET hits = hits + 1
         WHERE ip = some_ip;
      ELSE
         INSERT INTO table1
            (ip)
         VALUES
            (some_ip);
      END IF;
But same error still appears
Thank You
		
	В списке pgsql-general по дате отправления: