Re: making a rule and know when it is violated

On Tue, 22 Feb 2005, Nico wrote:

> What is the message returned by the sqlexception if such an index is
> violated? I searched it on google.com, but didn't find much interesting,
> probably using the wrong keywords...

You could of course take the ten seconds necessary to try it:

jurka=# create table ut (a int primary key);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ut_pkey"
for table "ut"
CREATE TABLE
jurka=# insert into ut values (1);
INSERT 608266 1
jurka=# insert into ut values (1);
ERROR:  duplicate key violates unique constraint "ut_pkey"

Kris Jurka