Re: insert duplicated unique/PK with no errors

On Thu, 25 Sep 2003, Gaetano Mendola wrote:

> Mirek Rusin wrote:
>
> > ...what is the best way to force duplicated unique
> > or primary key'ed row inserts not to raise errors?
>
> Doesn't make sense, am I missing the point ?

I think what he may want is:

create table test (id serial primary key, info text unique);
begin;
insert into test values (DEFAULT,'abc');
INSERT 1
insert into test values (22,'def');
INSERT 1
insert into test values (22,'def');
INSERT 0
commit;

In order to do this, you'll need triggers that fire on the unique / pk
before insertion, and if the values would be dups, to simply drop the
insert silently.

Can that be done, by the way?