Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aORcU-00040Z-LB for pgsql-admin@arkaria.postgresql.org; Wed, 27 Jan 2016 15:02:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aORcU-0003Os-7n for pgsql-admin@arkaria.postgresql.org; Wed, 27 Jan 2016 15:02:54 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aORao-0001Tx-Uf for pgsql-admin@postgresql.org; Wed, 27 Jan 2016 15:01:11 +0000 Received: from forward16o.cmail.yandex.net ([37.9.109.213]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aORak-0003dN-6z for pgsql-admin@postgresql.org; Wed, 27 Jan 2016 15:01:09 +0000 Received: from web20o.yandex.ru (web20o.yandex.ru [IPv6:2a02:6b8:0:1a2d::5:120]) by forward16o.cmail.yandex.net (Yandex) with ESMTP id C54C52073C; Wed, 27 Jan 2016 18:00:54 +0300 (MSK) Received: from 127.0.0.1 (localhost [127.0.0.1]) by web20o.yandex.ru (Yandex) with ESMTP id ECD83EE2923; Wed, 27 Jan 2016 18:00:53 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1453906854; bh=SngYAg8SjU3FGjBP5c4wsLJ1aQqCQjpnlpxMXs5Chlg=; h=From:To:In-Reply-To:References:Subject:Date; b=DrDYPOmlMyrY6pRdMfjxO4xh0W/9fcLO+9sqYeXzoKQiMSAfIHOaR0FzItmbPE3oo iflYwE1gtExuuM4NYnM8Vf8o5ntE7CvNqlblVcW1DSUZQ6szdBDoKqH3+5ntUjVDjl 2PBlUwyfaBEgnz2oar0B9GoyjupD3q4I1T83sjbY= Received: by web20o.yandex.ru with HTTP; Wed, 27 Jan 2016 18:00:53 +0300 From: Samed YILDIRIM To: Albe Laurenz , 'Artem Tomyuk *EXTERN*' , "pgsql-admin@postgresql.org" In-Reply-To: References: Subject: Re: Insert in table with UNIQUE index MIME-Version: 1.0 Message-Id: <37051453906853@web20o.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 27 Jan 2016 17:00:53 +0200 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org PGRpdj5IaSBBcnRlbSw8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5Zb3UgY2FuIHNlZSBleGFjdCBz YW1lIHJlY29yZCBpbiB5b3VyIHNlbGVjdCByZXN1bHRzIGZyb23CoF9pbmZvZ2NuZ3I2NzE2X3Rl c3QgdGFibGUgZGVzcGl0ZSB1bmlxIGluZGV4IGV4aXN0cywgaWYgeW91IGNyZWF0ZSBhIHRhYmxl IGluaGVyaXRlZCBmcm9tIHRoZSB0YWJsZS48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5Gb3IgZXhh bXBsZTo8L2Rpdj48ZGl2PkNyZWF0ZSBpbmhlcml0ZWQgdGFibGU8L2Rpdj48ZGl2PjxzcGFuIHN0 eWxlPSJmb250LWZhbWlseTp0ZXJtaW5hbCxtb25hY287Zm9udC1zaXplOngtc21hbGw7Ij5DUkVB VEUgVEFCTEUgcHVibGljLl9pbmZvcmdjbmdyNjcxNl90ZXN0X2NoaWxkPC9zcGFuPjxiciAvPjxz cGFuIHN0eWxlPSJmb250LWZhbWlseTp0ZXJtaW5hbCxtb25hY287Zm9udC1zaXplOngtc21hbGw7 Ij4oPC9zcGFuPjxiciAvPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTp0ZXJtaW5hbCxtb25hY287 Zm9udC1zaXplOngtc21hbGw7Ij7CoMKgIExJS0UgcHVibGljLl9pbmZvcmdjaG5ncjY3MTZfdGVz dCBJTkNMVURJTkcgREVGQVVMVFMgSU5DTFVESU5HIENPTlNUUkFJTlRTIElOQ0xVRElORyBJTkRF WEVTPC9zcGFuPjxiciAvPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTp0ZXJtaW5hbCxtb25hY287 Zm9udC1zaXplOngtc21hbGw7Ij4pIDwvc3Bhbj48YnIgLz48c3BhbiBzdHlsZT0iZm9udC1mYW1p bHk6dGVybWluYWwsbW9uYWNvO2ZvbnQtc2l6ZTp4LXNtYWxsOyI+SU5IRVJJVFMgKF9pbmZvcmdj aG5ncjY3MTZfdGVzdCk8L3NwYW4+PGJyIC8+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OnRlcm1p bmFsLG1vbmFjbztmb250LXNpemU6eC1zbWFsbDsiPldJVEggKDwvc3Bhbj48YnIgLz48c3BhbiBz dHlsZT0iZm9udC1mYW1pbHk6dGVybWluYWwsbW9uYWNvO2ZvbnQtc2l6ZTp4LXNtYWxsOyI+wqAg T0lEUyA9IEZBTFNFPC9zcGFuPjxiciAvPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTp0ZXJtaW5h bCxtb25hY287Zm9udC1zaXplOngtc21hbGw7Ij4pOzwvc3Bhbj48L2Rpdj48ZGl2PsKgPC9kaXY+ PGRpdj5JbnNlcnQgc2FtZSByZWNvcmRzIGludG8gdGhlc2UgdHdvIHRhYmxlLiAoTm8gZXJyb3Ig cmV0dXJucyk8L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTp0ZXJtaW5hbCxtb25h Y287Zm9udC1zaXplOngtc21hbGw7Ij5JTlNFUlQgSU5UTyBfaW5mb2djbmdyNjcxNl90ZXN0X2No aWxkKDwvc3Bhbj48YnIgLz48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6dGVybWluYWwsbW9uYWNv O2ZvbnQtc2l6ZTp4LXNtYWxsOyI+wqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBfbm9kZXRyZWYsIF9u b2RlcnJlZiwgX21lc3NhZ2Vubyk8L3NwYW4+PGJyIC8+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5 OnRlcm1pbmFsLG1vbmFjbztmb250LXNpemU6eC1zbWFsbDsiPsKgwqDCoCBWQUxVRVMgKCdhc2Qn LCAnYXNkJywxMCk7PC9zcGFuPjxiciAvPjxiciAvPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTp0 ZXJtaW5hbCxtb25hY287Zm9udC1zaXplOngtc21hbGw7Ij5JTlNFUlQgSU5UTyBfaW5mb2djbmdy NjcxNl90ZXN0KDwvc3Bhbj48YnIgLz48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6dGVybWluYWws bW9uYWNvO2ZvbnQtc2l6ZTp4LXNtYWxsOyI+wqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBfbm9kZXRy ZWYsIF9ub2RlcnJlZiwgX21lc3NhZ2Vubyk8L3NwYW4+PGJyIC8+PHNwYW4gc3R5bGU9ImZvbnQt ZmFtaWx5OnRlcm1pbmFsLG1vbmFjbztmb250LXNpemU6eC1zbWFsbDsiPsKgwqDCoCBWQUxVRVMg KCdhc2QnLCAnYXNkJywgMTApOzwvc3Bhbj48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5NYWtlIHNl bGVjdCBxdWVyeSB0byBwYXJlbnQgdGFibGU8L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZh bWlseTp0ZXJtaW5hbCxtb25hY287Zm9udC1zaXplOngtc21hbGw7Ij5TRUxFQ1QgX25vZGV0cmVm LCBfbm9kZXJyZWYsIF9tZXNzYWdlbm88L3NwYW4+PGJyIC8+PHNwYW4gc3R5bGU9ImZvbnQtZmFt aWx5OnRlcm1pbmFsLG1vbmFjbztmb250LXNpemU6eC1zbWFsbDsiPsKgIEZST00gX2luZm9yZ2No bmdyNjcxNl90ZXN0Ozwvc3Bhbj48YnIgLz48YnIgLz48L2Rpdj48ZGl2PiJhc2QiOyJhc2QiOzEw PGJyIC8+ImFzZCI7ImFzZCI7MTA8YnIgLz48YnIgLz48L2Rpdj48ZGl2PjxkaXY+TWFrZSBzZWxl Y3QgcXVlcnkgdG8gb25seSBwYXJlbnQgdGFibGU8L2Rpdj48c3BhbiBzdHlsZT0iZm9udC1mYW1p bHk6dGVybWluYWwsbW9uYWNvO2ZvbnQtc2l6ZTp4LXNtYWxsOyI+U0VMRUNUIF9ub2RldHJlZiwg X25vZGVycmVmLCBfbWVzc2FnZW5vPC9zcGFuPjxiciAvPjxzcGFuIHN0eWxlPSJmb250LWZhbWls eTp0ZXJtaW5hbCxtb25hY287Zm9udC1zaXplOngtc21hbGw7Ij7CoCBGUk9NIE9OTFkgX2luZm9y Z2NobmdyNjcxNl90ZXN0Ozwvc3Bhbj48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj4iYXNkIjsiYXNk IjsxMDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsSweWkgw6dhbMSxxZ9tYWxhci48L2Rpdj48ZGl2 PlNhbWVkIFlJTERJUklNPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9k aXY+PGRpdj4yNy4wMS4yMDE2LCAxNjoxNCwgIkFsYmUgTGF1cmVueiIgJmx0O2xhdXJlbnouYWxi ZUB3aWVuLmd2LmF0Jmd0Ozo8L2Rpdj48YmxvY2txdW90ZSB0eXBlPSJjaXRlIj48cD5BcnRlbSBU b215dWsgd3JvdGU6PC9wPjxibG9ja3F1b3RlPsKgSSBoYXZlIGEgdGFibGUgd2l0aCB1bmlxdWUg aW5kZXggd2l0aCAyIGV4YWN0bHkgdGhlIHNhbWUgcm93cy48YnIgLz7CoEhvdyBpdCBjYW4gYmUg cG9zc2libGU/PGJyIC8+PGJyIC8+PGJyIC8+wqBDUkVBVEUgVEFCTEUgX2luZm9yZ2NobmdyNjcx Nl90ZXN0PGJyIC8+wqAoPGJyIC8+wqDCoMKgX25vZGV0cmVmIGJ5dGVhIE5PVCBOVUxMLDxiciAv PsKgwqDCoF9ub2RlcnJlZiBieXRlYSBOT1QgTlVMTCw8YnIgLz7CoMKgwqBfbWVzc2FnZW5vIG51 bWVyaWMoMTAsMCk8YnIgLz7CoCk8YnIgLz7CoFdJVEggKDxiciAvPsKgwqDCoE9JRFM9RkFMU0U8 YnIgLz7CoCk7PGJyIC8+wqBBTFRFUiBUQUJMRSBfaW5mb3JnY2huZ3I2NzE2X3Rlc3Q8YnIgLz7C oMKgwqBPV05FUiBUTyBwb3N0Z3Jlczs8YnIgLz48YnIgLz7CoC0tIEluZGV4OiBfaW5mb3JnNjcx Nl9ieW5vZGVtc2dfcm5fdGVzdDxiciAvPjxiciAvPsKgLS0gRFJPUCBJTkRFWCBfaW5mb3JnNjcx Nl9ieW5vZGVtc2dfcm5fdGVzdDs8YnIgLz48YnIgLz7CoENSRUFURSBVTklRVUUgSU5ERVggX2lu Zm9yZzY3MTZfYnlub2RlbXNnX3JuX3Rlc3Q8YnIgLz7CoMKgwqBPTiBfaW5mb3JnY2huZ3I2NzE2 X3Rlc3Q8YnIgLz7CoMKgwqBVU0lORyBidHJlZTxiciAvPsKgwqDCoChfbm9kZXRyZWYsIF9ub2Rl cnJlZiwgX21lc3NhZ2Vubyk7PC9ibG9ja3F1b3RlPjxwPjxiciAvPk1heWJlIGluZGV4IGNvcnJ1 cHRpb24uPGJyIC8+RGlkIHlvdSBoYXZlIGFueSBjcmFzaGVzPzxiciAvPjxiciAvPkRvIHlvdSBn ZXQgYW4gZXJyb3Igd2hlbiB5b3U8YnIgLz7CoMKgwqBSRUlOREVYIElOREVYIF9pbmZvcmc2NzE2 X2J5bm9kZW1zZ19ybl90ZXN0OzxiciAvPjxiciAvPllvdXJzLDxiciAvPkxhdXJlbnogQWxiZTxi ciAvPjxiciAvPjwvcD48c3Bhbj4tLSA8YnIgLz5TZW50IHZpYSBwZ3NxbC1hZG1pbiBtYWlsaW5n IGxpc3QgKDxhIGhyZWY9Im1haWx0bzpwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZyI+cGdzcWwt YWRtaW5AcG9zdGdyZXNxbC5vcmc8L2E+KTxiciAvPlRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1 YnNjcmlwdGlvbjo8YnIgLz48YSBocmVmPSJodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxw cmVmL3Bnc3FsLWFkbWluIj5odHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3Fs LWFkbWluPC9hPjxiciAvPjwvc3Bhbj48L2Jsb2NrcXVvdGU+