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?