|
Table is defined as
CREATE TABLE firma1.klient (
kood character(12) NOT NULL DEFAULT
nextval('firma1.klient_kood_seq'::regclass),
....
);
How to insert record to this table only if primary key does not exist
?
I tried code below but got strange error as shown in log file.
Why this error occurs ?
Andrus.
2012-06-30 15:51:04 EEST ERROR: duplicate key value violates unique
constraint "klient_pkey"
2012-06-30 15:51:04 EEST DETAIL: Key
(kood)=(20037 ) already exists.
2012-06-30 15:51:04 EEST STATEMENT: insert into klient (
kood,
nimi,
tanav,
piirkond,
postiindek
)
select ((E'20037')), ((E'Statoil Fuel & Retail')),
((E'')), ((E'10148 nnn')),((E''))
from klient
where not exists (select 1 from klient where kood
=((E'20037')))
|
