BUG #14389: Duplicate rows on tables with unique index constrain - Mailing list pgsql-bugs
From | mahmoudhakh@gmail.com |
---|---|
Subject | BUG #14389: Duplicate rows on tables with unique index constrain |
Date | |
Msg-id | 20161021093200.1411.62581@wrigleys.postgresql.org Whole thread Raw |
List | pgsql-bugs |
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM4OQpMb2dnZWQgYnk6ICAg ICAgICAgIE1haG1vdWQgSGFrZWVtLUhhYmVlYgpFbWFpbCBhZGRyZXNzOiAg ICAgIG1haG1vdWRoYWtoQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDkuNC40Ck9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudG9zIDYuNgpEZXNjcmlw dGlvbjogICAgICAgIAoKSGksDQpJIGhhdmUgbm90aWNlZCBhbiBpc3N1ZSB3 aXRoIHJvd3Mgbm90IGhvbm91cmluZyB0aGUgdW5pcXVlIGluZGV4CmNvbnN0 cmFpbi4NCkkgZmlyc3QgY2FtZSBhY3Jvc3MgdGhlIGlzc3VlIHdoZW4gdXBn cmFkaW5nIGZyb20gOS4yLjQgdG8gOS40LjQsIGkgZ290IHRoZQplcnJvciBi ZWxvdw0KDQpwZ19yZXN0b3JlOiBbYXJjaGl2ZXIgKGRiKV0gRXJyb3Igd2hp bGUgUFJPQ0VTU0lORyBUT0M6DQpwZ19yZXN0b3JlOiBbYXJjaGl2ZXIgKGRi KV0gRXJyb3IgZnJvbSBUT0MgZW50cnkgNjY2NjsgMTI1OSAyOTc1OTcwMiBJ TkRFWAppZHhkb21haW5pZCBwb3N0Z3Jlcw0KcGdfcmVzdG9yZTogW2FyY2hp dmVyIChkYildIGNvdWxkIG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJPUjogIGNv dWxkIG5vdApjcmVhdGUgdW5pcXVlIGluZGV4ICJpZHhkb21haW5pZCINCkRF VEFJTDogIEtleSAoaWQsIGRvbWFpbik9KDMsIHBlb3BsZS5uZXQpIGlzIGR1 cGxpY2F0ZWQuDQogICAgQ29tbWFuZCB3YXM6IENSRUFURSBVTklRVUUgSU5E RVggaWR4ZG9tYWluaWQgT04gZG9tYWlucyBVU0lORyB0cmVlIChpZCwKZG9t YWluKTsNCg0KSW4gdGhlIGFib3ZlIGNhc2UgaSByb2xsZWQgYmFjayBhbmQg ZGVsZXRlZCB0aGUgb2ZmZW5kaW5nIHJvdywgYW5kIHRoZW4KdXBncmFkZWQg c3VjY2Vzc2Z1bGx5Lg0KDQpUaGVuIGkgc3RhcnRlZCBzZWVpbmcgbW9yZSBv ZiB0aGUgaXNzdWUsIGR1cmluZyBteSB1cGdyYWRlIHNvIGkgc3RvcHBlZCBh bmQKcmFuIGEgY2hlY2sgdG8gZmluZCBhbnkgZHVwbGljYXRlcyB1c2luZyAN CkJFR0lOOw0KICBzZXQgZW5hYmxlX2luZGV4c2NhbiB0byBmYWxzZTsNCiAg c2V0IGVuYWJsZV9iaXRtYXBzY2FuIHRvIGZhbHNlOw0KICBzZWxlY3QgY291 bnQoKiksIGlkLCBkb21haW4gZnJvbSBkb21haW5zIGdyb3VwIGJ5IGlkLCBk b21haW4gaGF2aW5nCmNvdW50KCopID4gMTsNCiBST0xMQkFDSzsNCg0KSSBm b3VuZCB0aGUgc2FtZSBpc3N1ZSBvbiBzZXJ2ZXJzIHJ1bm5pbmcgOS4yLjQg YW5kIDkuNC40IGFuZCBhbHNvIGZvdW5kIGl0CmhhcHBlbmluZyBvbiBhIG51 bWJlciBvZiB0YWJsZXMuDQoNClRoZSBiZWxvdyBpcyBvbmUgaSBoYXZlIG5v dCBmaXhlZCBhcyBpIGFtIHVzaW5nIGl0IHJlcG9ydCB0aGlzIGJ1ZyBvciBm aW5kCnRoZSBjYXVzZS4NCkkgYWxzbyBoYXZlIGEgZmV3IG1vcmUgc2VydmVy cyB3aXRoIHRoZSBzYW1lIGlzc3VlLg0KDQpkYj0+IHNlbGVjdCB2ZXJzaW9u KCk7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgdmVyc2lvbg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQog UG9zdGdyZVNRTCA5LjQuNCBvbiB4ODZfNjQtdW5rbm93bi1saW51eC1nbnUs IGNvbXBpbGVkIGJ5IGdjYyAoR0NDKSA0LjQuNwoyMDEyMDMxMyAoUmVkIEhh dCA0LjQuNy0xMSksIDY0LWJpdA0KKDEgcm93KQ0KDQpkYj0+IHNlbGVjdCBz aWQsZG9tYWluLGlkIGZyb20gZG9tYWlucyB3aGVyZSBkb21haW4gPSAnbW9y bmV0Lm5ldCcgYW5kIGlkCj0zOw0KICBzaWQgICB8IGRvbWFpbiB8IGlkDQot LS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLQ0KIDE4NjYyMTM1 IHwgbW9ybmV0Lm5ldCB8ICAgICAgICAgMw0KDQpkYj0+IHNldCBlbmFibGVf aW5kZXhzY2FuIHRvIGZhbHNlOw0KU0VUDQpkYj0+IHNldCBlbmFibGVfYml0 bWFwc2NhbiB0byBmYWxzZTsNClNFVA0KZGI9PiBzZWxlY3QgY291bnQoKiks IGlkLCBkb21haW4gZnJvbSBkb21haW5zIGdyb3VwIGJ5IGlkLCBkb21haW4g aGF2aW5nCmNvdW50KCopID4gMTsNCiBjb3VudCB8IGlkIHwgICAgIGRvbWFp bg0KLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0N CiAgICAgMiB8ICAgICAgICAgMyB8IG1vcm5ldC5uZXQNCg0KZGI9PiBzZWxl Y3Qgc2lkLGRvbWFpbixpZCBmcm9tIGRvbWFpbnMgd2hlcmUgZG9tYWluID0g J21vcm5ldC5uZXQnIGFuZCBpZAo9MzsNCiAgc2lkICAgfCBkb21haW4gfCBp ZA0KLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0NCiAgIDI2 NjU4MSB8IG1vcm5ldC5uZXQgfCAgICAgICAgIDMNCiAxODY2MjEzNSB8IG1v cm5ldC5uZXQgfCAgICAgICAgIDMNCg0KZGI9PiBzZXQgZW5hYmxlX2luZGV4 c2NhbiB0byB0cnVlOw0KU0VUDQpkYj0+IHNldCBlbmFibGVfYml0bWFwc2Nh biB0byB0cnVlOw0KU0VUDQoNCmRiPT4gc2VsZWN0IHNpZCxkb21haW4saWQg ZnJvbSBkb21haW5zIHdoZXJlIGRvbWFpbiA9ICdtb3JuZXQubmV0JyBhbmQg aWQKPTM7DQogIHNpZCAgIHwgZG9tYWluIHwgaWQNCi0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tKy0tLS0tLS0tLS0tDQogMTg2NjIxMzUgfCBtb3JuZXQubmV0 IHwgICAgICAgICAzDQoNCmRiPT4gXGQgZG9tYWlucw0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgVGFibGUgInB1YmxpYy5kb21haW5z Ig0KICAgICBDb2x1bW4gICAgIHwgICAgICAgVHlwZSAgICAgICAgfCAgICAg ICAgICAgICAgICAgICAgICAgIE1vZGlmaWVycw0KLS0tLS0tLS0tLS0tLS0t LSstLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIHNpZCAgICAg ICAgICAgIHwgYmlnaW50ICAgICAgICAgICAgfCBub3QgbnVsbCBkZWZhdWx0 Cm5leHR2YWwoJ2RvbWFpbnNfc2lkX3NlcSc6OnJlZ2NsYXNzKQ0KIGlkICAg ICAgICAgICAgIHwgYmlnaW50ICAgICAgICAgICAgfCBub3QgbnVsbA0KIGRv bWFpbiAgICAgICAgIHwgY2hhcmFjdGVyIHZhcnlpbmcgfCBub3QgbnVsbA0K IHNlbmRvbmx5ICAgICAgIHwgYm9vbGVhbiAgICAgICAgICAgfCBkZWZhdWx0 IGZhbHNlDQogc3BhY2Vkb21haW4gICAgfCBib29sZWFuICAgICAgICAgICB8 IGRlZmF1bHQgZmFsc2UNCiBvdXRib3VuZGNoZWNrcyB8IHNtYWxsaW50ICAg ICAgICAgIHwgZGVmYXVsdCAwDQogbm9ybWFsaXNlZCAgICAgfCBjaGFyYWN0 ZXIgdmFyeWluZyB8DQpJbmRleGVzOg0KICAgICJkb21haW5zX3BrZXkiIFBS SU1BUlkgS0VZLCBidHJlZSAoc2lkKQ0KICAgICJpZHhkb21haW5pZCIgVU5J UVVFLCBidHJlZSAoaWQsIGRvbWFpbikNCg0KSWYgeW91IHJlcXVpcmUgYW55 IG1vcmUgaW5mbyBwbGVhc2UgbGV0IG1lIGtub3cgYW5kIGkgd2lsbCBwcm92 aWRlIHdoYXQgaQpjYW4uDQoNCiBUaGlzIGlzIHNpbWlsYXIgdG8gdGhlIGJ1 ZyByZXBvcnRlZCBidWcgIzEzOTM1DQoKaHR0cHM6Ly93d3cucG9zdGdyZXNx bC5vcmcvbWVzc2FnZS1pZC9mbGF0LzIwMTYwMjA4MTYzMjIyLjI2NjEuNTE2 MDglNDB3cmlnbGV5cy5wb3N0Z3Jlc3FsLm9yZyMyMDE2MDIwODE2MzIyMi4y NjYxLjUxNjA4QHdyaWdsZXlzLnBvc3RncmVzcWwub3JnDQpUaGFua3MsDQpN YWhtb3VkCgo=
pgsql-bugs by date: